Extract a string from a cell
 

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

I want to extract only the Lastname

Extract a string from a cell
 

Try this:

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

Copy down as needed.
--

HTH,

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


"MrLarrier" wrote in message
...
I have a column of data in this format
Lastname, Firstname

I want to extract only the Lastname

Extract a string from a cell
 

Use this in a helper column:

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

and then copy down as required.

Hope this helps.

Pete


On Jan 13, 4:31*pm, MrLarrier
wrote:
I have a column of data in this format
Lastname, Firstname

I want to extract only the Lastname

Extract a string from a cell
 

=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.
--
David Biddulph


"MrLarrier" wrote in message
...
I have a column of data in this format
Lastname, Firstname

I want to extract only the Lastname