Number removal

J

Jennings

I have a sheet with 10K part numbers that are 10 digits long

Example

5300000030
5301620220
5301621300
5301621610

Is there a way of removing the last digit to make them all 9 digits
long without editing each cell?

example

530000003
530162022
530162130
530162161
 
D

daddylonglegs

....this formula can then be autofilled down. If you wish use Copy the
Edit > Paste Special > Values to overwrite original dat
 
D

Domenic

Assuming that Column A contains your data, enter the following formula
in B1, and copy down:

=LEFT(A1,LEN(A1)-1)

Then, if you'd like to convert these formulas into values, try the
following...

1) Select Column B

2) Edit > Copy > Edit > Paste Special > Values > Ok

Hope this helps!
 
Top