Formula to pull out last names

[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

 

[Bob Phillips]

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)

 

[Marie]

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

 

[Stephanie]

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)




.