text in a PDF form
 

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

text in a PDF form
 

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

text in a PDF form
 

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.



"muddan madhu" wrote:

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

.

text in a PDF form
 

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

"rzink" wrote:

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.



"muddan madhu" wrote:

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

.