With your first example in A1, use this:

=LEFT(A1,FIND(":",A1,1)-2)

HTH
Jim

"GAUS" wrote:

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