View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
GAUS GAUS is offline
external usenet poster
 
Posts: 1
Default 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