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" <Rowf@discussions.microsoft.com> wrote in message
news:E710780F-6B6F-45A7-AF6D-0D69863BC9CA@microsoft.com...
>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.