Need of Excel Formula

  • Thread starter Thread starter GAUS
  • Start date Start date
G

GAUS

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
 
On the off chance that the name can be followed by either no or many spaces
before the colon...

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

Rick
 
How about Data>Text to Columns>Delimited by>Other.........enter a colon and Next

Select the second column and "Do not import" and Finish.


Gord Dibben MS Excel MVP
 
Back
Top