Need of Excel Formula
Can u help me out?
In the below example you can see there are person names with their ID. So
can you suggest formula in excel by which i can get only person names in a
cell e.g. William Henry only.
Willam Henry :ID AZ_WILHEN
Robert Patricia :ID AZ_ROBPAT
Gomzy Parker :ID AZ_GOMPAR
I am confuse how to ignore data which is appearing from ":ID "
Awaiting for Your reply and mail me on my ID only
Thanks,
Gaus Shaikh
|