Hi,

You can have a macri if you want but put this in an adjacent column and
double clivk the fill handle and it will fill down as far as there are data
in an adjacent column and remove the last character.

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

Mike

"K Drier" wrote:

I have a column of numbers that end with an alpha character. I need to
remove the alpha character and I'd like to write a macro or formula to do it
automatically since the column is about 1000 numbers long.

I got the macro to work once, but it won't work again on the balance of the
column. Would someone please help me figure out what I need to do to make
this an automatic process so I can reuse it at a later date?

Thanks so much!