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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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,

Try this.

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

HTH

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

=IF(RIGHT(A1,1)="v",LEFT(A1,LEN(A1)-1),A1)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

remove last character in a series of different length part #'s 3
Sorting Columns by number of characters 1
2nd and 3rd last number in a column - how to get it? 4
Curve fitting with weighted trendline 1
Cut the last 20 characters out of a text string 4
How do I compare the stored data in micro 3
Letter and space count in cell 1
Sorting and Formulas 1

Back
Top