Extract a string from a cell

[MrLarrier]

I have a column of data in this format
Lastname, Firstname

I want to extract only the Lastname

 

[RagDyeR]

Try this:

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

Copy down as needed.
--

HTH,

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


I have a column of data in this format
Lastname, Firstname

I want to extract only the Lastname

 

[Pete_UK]

Use this in a helper column:

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

and then copy down as required.

Hope this helps.

Pete

 

[David Biddulph]

=LEFT(A2,FIND(",",A2)-1) is one option.

Another method is to use Data/ Text to Columns, delimited by commas, and
tell it to skip the second column.