Thread: remove last character in a column of part numbers if a "V"
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
CLR
 
Posts: n/a
Default 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?
Reply With QuoteReply With Quote