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...
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.