remove last character in a series of different length part #'s

leo · Dec 8, 2005

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.

Dave Peterson · Dec 8, 2005

If the v only shows up in the last character, maybe just
select your range
edit|replace
what: v
with: leave blank
replace all

If you don't want to do that, maybe a helper column of cells:

=left(a1,len(a1)-1)
drag down
copy|paste special|values
and delete the original column

leo · Dec 8, 2005

worked like a chram, thx,leo

Dave Peterson said:
If the v only shows up in the last character, maybe just
select your range
edit|replace
what: v
with: leave blank
replace all

If you don't want to do that, maybe a helper column of cells:

=left(a1,len(a1)-1)
drag down
copy|paste special|values
and delete the original column

Ed Ferrero · Dec 12, 2005

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