View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Beege Beege is offline
external usenet poster
 
Posts: 66
Default 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