Import as Text VBA Macro.

[saturos]

Import as text.xlsx

Hey guys
Just wondering. I know excel import as text is awesome.
But the thing is, when i have 10 reports to do, and each time, i have to copy from PDF, open txt file, paste in a txt file and save, and import it in from excel, it hits away on my time

Anyways, i wonder if there is a VBA macro which does exactly what import as text does? (with space separators).

that means for example
A1=Quarter Revenue 1,671,718 1,483,937 13% 4,976,318 5,434,753 -8%

becomes
b1 = Quarter Revenue
c1 = 1,671,718
d1 = 1,483,937
e1 = 13%
etc

[patel45]

open macro recorder, select A1, Data, Text to Columns, ..... , close macro recorder

[saturos]

ah.

such an easy solution.
I guess there is no way for me to "re-allign" the text and numbers automatically?

for example, Quarterly Revenue i want it to be in the same cell despite it having a space.

[patel45]

you need different separators