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

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?

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

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


"leo" wrote:

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?

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

Leo,

Try this.

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

HTH

Steve


--
SteveG
------------------------------------------------------------------------
SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=502521

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

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

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


--
Gary Brown
------------------------------------------------------------------------
Gary Brown's Profile: http://www.excelforum.com/member.php...o&userid=17084
View this thread: http://www.excelforum.com/showthread...hreadid=502521