Trim cells to a character

[Guest]

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

 

[Beege]

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

 

[Rowland]

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

 

[Don Guillett]

This is NOT lotus. Lose the +
and LEFT would have been better here.