Home

PDF to excel. Splitting out Text from numbers

%3CLINGO-SUB%20id%3D%22lingo-sub-290976%22%20slang%3D%22en-US%22%3EPDF%20to%20excel.%20Splitting%20out%20Text%20from%20numbers%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-290976%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20PDF%20(cannot%20convert)%20that%20has%20a%20combination%20of%20both%20text%20and%20numbers.%20I%20can%20do%20straight%20copy%20and%20paste%20into%20excel%20without%20the%20need%20to%20delimit.%20On%20the%20spreadsheet%20a%20persons%20name%20may%20be%20in%20column%20A%2CB%2CC%20and%20D%20whereas%20some%20may%20only%20be%20A%20%26amp%3B%20B%20or%20A%2CB%20%26amp%3B%20C.%20I%20need%20to%20filter%20out%20or%20custom%20sort%20in%20a%20easy%20manner%20to%20make%20the%20text%20fields%20blanks%20and%20keep%20the%20cells%20that%20have%20numbers.%20As%20the%20spreadsheet%20can%20be%20up%20to%20800%20lines%20I%20find%20if%20I%20filter%20I%20am%20either%20ticking%20or%20unticking%20the%20text%20or%20numbers%20for%20each%20column%20and%20its%20time%20consuming.%20The%20other%20option%20is%20to%20custom%20sort%20and%20again%20highlight%20all%20cells%20in%20each%20column%20and%20clear.%20Any%20help%20greatly%20appreciated.%20I%20figure%20as%20I%20want%20to%20make%20the%20text%20blank%20it%20cant%20be%20too%20hard.%20This%20will%20be%20a%20regular%20report%20so%20if%20I%20can%20set%20something%20up%20to%20be%20a%20template%20this%20would%20be%20ideal.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-290976%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-357368%22%20slang%3D%22en-US%22%3ERe%3A%20PDF%20to%20excel.%20Splitting%20out%20Text%20from%20numbers%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-357368%22%20slang%3D%22en-US%22%3EHas%20this%20worked%20out%20for%20you%3F%3CBR%20%2F%3E%22did%20you%20try%20to%20use%20ISNUMBER%3F%20if%20numbers%20are%20imported%20as%20string%20you%20can%20try%20to%20multiply%20them%20with%201%20and%20check%20also.%20for%20example%20if%20your%20value%20is%20in%20A1%20then%3CBR%20%2F%3E%3DISNUMBER(A1*1)%3CBR%20%2F%3Ewill%20return%20true%20else%20it%20will%20be%20false.%20Combined%20with%20if%20this%20formula%20can%20extract%20what%20you%20need%3CBR%20%2F%3E%3DIF(ISNUMBER(A1*1)%3BA1*1%3B%22%22)%20%22%3CBR%20%2F%3E%3CBR%20%2F%3EI%20have%20mostly%20been%20using%203rd%20party%20utilities%20such%20as%20PDF%20Converter%3A%20%3CA%20href%3D%22https%3A%2F%2Fwww.coolutils.com%2FTotalPDFConverter%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.coolutils.com%2FTotalPDFConverter%3C%2FA%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-293099%22%20slang%3D%22en-US%22%3ERe%3A%20PDF%20to%20excel.%20Splitting%20out%20Text%20from%20numbers%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-293099%22%20slang%3D%22en-US%22%3E%3CP%3EThanks%20very%20much%20Erol.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-291151%22%20slang%3D%22en-US%22%3ERe%3A%20PDF%20to%20excel.%20Splitting%20out%20Text%20from%20numbers%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-291151%22%20slang%3D%22en-US%22%3E%3CP%3Edid%20you%20try%20to%20use%20ISNUMBER%3F%20if%20numbers%20are%20imported%20as%20string%20you%20can%20try%20to%20multiply%20them%20with%201%20and%20check%20also.%20for%20example%20if%20your%20value%20is%20in%20A1%20then%3C%2FP%3E%3CP%3E%3DISNUMBER(A1*1)%3C%2FP%3E%3CP%3Ewill%20return%20true%20else%20it%20will%20be%20false.%20Combined%20with%20if%20this%20formula%20can%20extract%20what%20you%20need%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3DIF(%3CSPAN%3EISNUMBER(A1*1)%3BA1*1%3B%22%22)%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Nicki Morley
Occasional Contributor

I have a PDF (cannot convert) that has a combination of both text and numbers. I can do straight copy and paste into excel without the need to delimit. On the spreadsheet a persons name may be in column A,B,C and D whereas some may only be A & B or A,B & C. I need to filter out or custom sort in a easy manner to make the text fields blanks and keep the cells that have numbers. As the spreadsheet can be up to 800 lines I find if I filter I am either ticking or unticking the text or numbers for each column and its time consuming. The other option is to custom sort and again highlight all cells in each column and clear. Any help greatly appreciated. I figure as I want to make the text blank it cant be too hard. This will be a regular report so if I can set something up to be a template this would be ideal. 

3 Replies

did you try to use ISNUMBER? if numbers are imported as string you can try to multiply them with 1 and check also. for example if your value is in A1 then

=ISNUMBER(A1*1)

will return true else it will be false. Combined with if this formula can extract what you need

 

=IF(ISNUMBER(A1*1);A1*1;"")

Thanks very much Erol.

Has this worked out for you?
"did you try to use ISNUMBER? if numbers are imported as string you can try to multiply them with 1 and check also. for example if your value is in A1 then
=ISNUMBER(A1*1)
will return true else it will be false. Combined with if this formula can extract what you need
=IF(ISNUMBER(A1*1);A1*1;"") "

I have mostly been using 3rd party utilities such as PDF Converter: https://www.coolutils.com/TotalPDFConverter
Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
21 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies