Need of Excel Formula

[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

 

[Jim]

With your first example in A1, use this:

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

HTH
Jim

 

[Don Guillett]

=LEFT(K3,FIND(":",K3)-1)

 

[Rick Rothstein \(MVP - VB\)]

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

 

[Gord Dibben]

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