software

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

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

=IF(RIGHT(A1,1)=quot;vquot;,LEFT(A1,LEN(A1)-1),A1)

then Copy gt; PasteSpecial gt; Values on that helper column and then replace
your original column A with it......Vaya con Dios,
Chuck, CABGx3quot;leoquot; wrote:

gt; i have a column of different length part numbers and want to remove the last
gt; letter if it is a quot;vquot; only..how do i do that?


Leo,

Try this.

=IF(RIGHT(A15,1)=quot;vquot;,LEFT(A15,LEN(A15)-1),quot;quot;)

HTH

Steve--
SteveG
------------------------------------------------------------------------
SteveG's Profile: www.excelforum.com/member.php...foamp;userid=7571
View this thread: www.excelforum.com/showthread...hreadid=502521
If the data is in cell A1, enter into B1 the following formula:-

=IF(RIGHT(A1,1)=quot;vquot;,LEFT(A1,LEN(A1)-1),A1)--
Gary Brown
------------------------------------------------------------------------
Gary Brown's Profile: www.excelforum.com/member.php...oamp;userid=17084
View this thread: www.excelforum.com/showthread...hreadid=502521