Thread: remove last character in a series of different length part #'s
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Ed Ferrero
 
Posts: n/a
Default remove last character in a series of different length part #'s
Hi leo,

This removes the last charachter
=LEFT(A1,LEN(A1)-1)

This removes the last charachter only if it is a "v"
=IF(RIGHT(A1,1)="v",LEFT(A1,LEN(A1)-1),A1)

Ed Ferrero
http://www.edferrero.com


i have a series of part numbers in a column in xl that vary in length but
all end in "v'. I want to remove just the "v". I tried text to coulmns and
all the functions i know.


Reply With QuoteReply With Quote