Serial Number List
 

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.

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

and copy down
--
Gary''s Student


"Rowf" wrote:

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.

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

Roger

"Rowf" wrote:

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.

Hi Rowf,

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

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

HTH
Regards,
Howard

"Rowf" wrote in message
...
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.