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.