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.
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.
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 wrote:
>
> 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
worked like a chram, thx,leo
"Dave Peterson" wrote:
> 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 wrote:
> >
> > 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
>
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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks