text in a PDF form

[CUTiger]

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

 

[muddan madhu]

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

 

[rzink]

Muddan's first formula will leave the number (829,1230, etc.) in a text
format. You need to add the Value() function to convert to a number.

=value(LEFT(A1,LEN(A1)-1))

This formula also assumes that you only have 1 letter to the right of the
number.

Hope this helps.

 

[CUTiger]

This works great and thanks....but one last question. how can I now convert
those numbers to time....8:29am and so on?