remove last character in a column of part numbers if a "V"

L

leo

i have a column of different length part numbers and want to remove the last
letter if it is a "v" only..how do i do that?
 
C

CLR

Assuming data is in column A, put this in a helper column and copy
down.........

=IF(RIGHT(A1,1)="v",LEFT(A1,LEN(A1)-1),A1)

then Copy > PasteSpecial > Values on that helper column and then replace
your original column A with it......


Vaya con Dios,
Chuck, CABGx3
 
G

Gary Brown

If the data is in cell A1, enter into B1 the following formula:-

=IF(RIGHT(A1,1)="v",LEFT(A1,LEN(A1)-1),A1)
 
Top