Pull First Name

  • Thread starter Thread starter miker1999
  • Start date Start date
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..
 
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...
 
miker1999,

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

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

John
 
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
 
Back
Top