Trim cells to a character
 

I have a colums of thousands of words. How do remove all the characters from
the right including the / sign. The words are of varying length.

aτaimar/KXYZfp

Trim cells to a character
 

Mike wrote:
I have a colums of thousands of words. How do remove all the characters from
the right including the / sign. The words are of varying length.

aτaimar/KXYZfp


Mike

Try the LEFT function with the FIND function.
Use a helper column, copy, paste special, values

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

Beege

Trim cells to a character
 

Try something like
=+MID(A1,1,FIND("/",A1)-1)

Mike wrote:
I have a colums of thousands of words. How do remove all the characters from
the right including the / sign. The words are of varying length.

aτaimar/KXYZfp

Trim cells to a character
 

This is NOT lotus. Lose the +
and LEFT would have been better here.
--
Don Guillett
SalesAid Software

"Rowland" wrote in message
...
Try something like
=+MID(A1,1,FIND("/",A1)-1)

Mike wrote:
I have a colums of thousands of words. How do remove all the characters
from the right including the / sign. The words are of varying length.

a?aimar/KXYZfp