in cell B1 =LEFT(A1,LEN(A1)-1)
in cell C1 =RIGHT(A1,1)

On Oct 22, 1:03*am, CUTiger wrote:
I converted a PDF file to excel but now have the data in the following form:
829a
1230p
153p
836a

and so on. *How can I drop the letters and format cell to numbers.

Thanks Gene