Pull First Name

M

miker1999

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

A1 = Smith, Mike

I would like to pull just the first name.

Help..
 
R

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...
 
J

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
 
B

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
 
Top