| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 . |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| User Form Text Boxes - Copy format of text boxes | Excel Discussion (Misc queries) | |||
| 2 criteria lookup of text. Return text form column 3. SUMPRODUCT t | Excel Worksheet Functions | |||
| Inserting text into a PDF form? | Excel Discussion (Misc queries) | |||
| Form Button - Changing Text | Excel Discussion (Misc queries) | |||
| DATE IN TEXT FORM - NEED TO CHANGE IT DATE FORM | New Users to Excel | |||
Linear Mode
