Are they all the same length?
If so, you can use Text To Columns, "Fixed Width", and use "Do Not Import"
to eliminate the "A", and have your data ready for use, *without* any
underlying formulas to perhaps have to get rid of later.
One way to go if you have varying lengths of data, is this Text formula,
which will leave you with the formula in the cell:
=LEFT(A1,LEN(A1)-1)
Besides having the formula in the cell, the actual return is also Text.
To convert to a true number for future calculations, simply add the double
negative:
=--LEFT(A1,LEN(A1)-1)
--
HTH,
RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================
I have hundreds of rows of numbers ending in suffix A (i.e. 100465A). I
want
to delete the suffix without manually deleting in each cell.
