trimng text

[Phil-e]

Is there a way to trim text strings after a comma(,). To avoid a lot of typing I need to copy and past from one sheet to another. The problem is that in the cell on the "copy sheet" it has (lastname, firstname middleinitial.) I only want the (lastname) pasted in the new sheet/cell. I need to cut every thing past the comma. Any ideas? THANKS

 

[Tom Urtis]

Maybe this will help, this formula will return whatever is in the cell to the left of the comma, A1 for example:

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

 

[acw]

Hi

Assuming the data is in A4 then

Left(Range("a4"), InStr(1, Range("a4"), ",") - 1)
will get all the data to the left of the comma. If you want to include the comma, then remove the -1.


Tony

 

[Phil-e]

Thanks Tom & ACE, that was quick. Just what I needed. Somtimes you can't see the forest for the trees.
Phil