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
Highlighted
Deleted
Not applicable

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
Highlighted

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;"")

Highlighted

Thanks very much Erol.

Highlighted
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