Pull First Name

[miker1999]

Hi all...this seems relatively easy, but need some help.

A1 = Smith, Mike

I would like to pull just the first name.

Help..

 

[Peo Sjoblom]

=TRIM(MID(A1,FIND(",",A1)+1,255))

 

[RagDyer]

Try:

=MID(A1,FIND(",",A1)+2,25)

--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


Hi all...this seems relatively easy, but need some help.

A1 = Smith, Mike

I would like to pull just the first name.

Help...

 

[John Wilson]

miker1999,

One way....
Using the comma as a separator, if your name is in A1 then

=RIGHT(A1,LEN(A1)-FIND(",",A1)-1)

John

 

[RagDyer]

Are Swedish names really that long Peo ?<g>
--


Regards,

RD

 

[Bonnie S.]

you can use:
Data
Text to columns
delimited (click next)
click comma (click next)
You can either separate the name smith, mike into two
columns
or just get rid of what you don't want by choose the
column by clicking on top of general and click the box
that says do not import column (skip)
this will just bring over all the last names in the same
cell.

But remember if you want to seperate the names into two
columns be sure you have an empty column next to "mike"

Hope that helps