Serial Number List

R

Rowf

I have a list of Serial Numbers that I need to remove the last digit. Anyone
know a quick and simple way of removing it.

M0808050001A -- remove the A
M0808050002C -- remove the C
M08080500039 -- remove the 9
etc

Any and all help would be greatly appreciated.
 
G

Gary''s Student

Assuming your numbers are in column A and 12 digits in length, in a near-by
column put
=LEFT(A1,11)

and copy down
 
R

RogerN

Quickest is Data/Text to Columns. Use fixed width, insert break and then
select "Do not import column".

Roger
 
L

L. Howard Kittle

Hi Rowf,

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

Fill down, then copy > paste special > values to get rid of fromulas.

HTH
Regards,
Howard
 
Top