M MrLarrier Jan 13, 2009 #1 I have a column of data in this format Lastname, Firstname I want to extract only the Lastname
R RagDyeR Jan 13, 2009 #2 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
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
P Pete_UK Jan 13, 2009 #3 Use this in a helper column: =LEFT(A1,FIND(",",A1)-1) and then copy down as required. Hope this helps. Pete
Use this in a helper column: =LEFT(A1,FIND(",",A1)-1) and then copy down as required. Hope this helps. Pete
D David Biddulph Jan 13, 2009 #4 =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.
=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.
