removing characters

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

Guest

How do you remove the last character ina string/cell

I have 8000 item ID that I have to strip the last charcter on. The last charater is an A,B,C or

Example: C-1201A what to make it C-120
 
And if you have lots of these all in a column and they're all 7 characters long,
you can use Data|text to columns.

choose fixed width
and draw a line between the 6th and 7th character
and choose "Do not import (skip)" for the last field.
 
Back
Top