Forum Discussion
PDF to excel. Splitting out Text from numbers
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 col...
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
"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