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

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.