text in a PDF form

  • Thread starter Thread starter CUTiger
  • Start date Start date
C

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'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.
 
This works great and thanks....but one last question. how can I now convert
those numbers to time....8:29am and so on?
 
Back
Top