Formula to pull out last names

  • Thread starter Thread starter Stephanie
  • Start date Start date
S

Stephanie

I need a formula to help me get only last names from a
list such as...

smith, joe
neilan, stephanie
fox, william

Any ideas?

Thanks in advance!
Stephanie
 
Stephanie,

This will work as long as the names are formatted as you show.

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

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
This worked for me...assuming contents are in cell B19:

=MID(B19,1,FIND(",",B19,1)-1)

Should display:
smith

You can copy this formula down the list. Marie
 
Works perfect! Thank you. :>
-----Original Message-----
Stephanie,

This will work as long as the names are formatted as you show.

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

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)




.
Click to expand...
 
Back
Top