Number removal
 

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


--
Jennings
------------------------------------------------------------------------
Jennings's Profile: http://www.excelforum.com/member.php...o&userid=31466
View this thread: http://www.excelforum.com/showthread...hreadid=512729

Number removal
 

In another column

=LEFT(a1,9)


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=512729

Number removal
 

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


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=512729

Number removal
 

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!

In article ,
Jennings
wrote:

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

Number removal
 

Thanks both ways work great !
Cheers


--
Jennings
------------------------------------------------------------------------
Jennings's Profile: http://www.excelforum.com/member.php...o&userid=31466
View this thread: http://www.excelforum.com/showthread...hreadid=512729