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

Need of Excel Formula
 

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

Need of Excel Formula
 

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

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"GAUS" wrote in message
...
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

Need of Excel Formula
 

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


"GAUS" wrote in message
...
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

Need of Excel Formula
 

How about DataText to ColumnsDelimited byOther.........enter a colon and Next

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


Gord Dibben MS Excel MVP

On Wed, 9 Apr 2008 09:11:00 -0700, 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