ExcelBanter - View Single Post - Removing an alpha characture from a column of numbers

David Biddulph[_2_]

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

"K Drier" <K wrote in message
...
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!