Left Trim

[Kerry Schneider]

Looking to left trim a cell to a specific character. i.e.
I have a column with "lastname, firstname". I wish to trim
to lastname only, is there a way to request a trim to the
comma? thanks...K

 

[Peo Sjoblom]

One way

select the column, do data>text to columns, delimited, click next,
select comma as delimiter, click next, click in the right hand
column to select it in the data preview window, select do not
import (skip), click finish

 

[Tim Otero]

Sure,
but instead of TRIM, use RIGHT:

=RIGHT(A1,FIND(",",A1,1))

tim

 

[Tim Otero]

OOPS!

Ignore this. I gave you firstname instead of lastname

tim=bonehead

 

[Kerry Schneider]

-----Original Message-----
Kerry,

Try the following formula:

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


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
www.cpearson.com (e-mail address removed)





.
Thanks Chip...worked like a charm...K

 

[Adrian]

Try this: =REPLACE(A1,1,LEN(A1),LEFT(A1,FIND(",",A1)-1))

Not as elegant as the other options though!

 

[Adrian]

One more lengthy option: =SUBSTITUTE(A1,A1,LEFT(A1,FIND(",",A1)-1))