An easy question

[filo666]

I have something I dont thing is difficult but still I dont know how to do it

When copyng and pasting info from acrobat I recieve the info in a single
cell, I want to paste it in different cells depending on the spaces:

in cells(1,1) is writen

Profit 7% 9% 15% 12% '(all toghether)

and I want this

cells(1,1) cells(1,2) cells(1,3) cells(1,4) cells(1,5)
Profit 7% 9% 15% 12%

TIA

 

[John Bundy]

Go to Data->Text to Columns->choose delimited, next, then check the box
beside Space, that should do it for you.

 

[filo666]

Thanks, could you send me the way to doit in a code

 

[Tom Ogilvy]

Turn on the macro recorder in Tools=>Macro=>Record a New Macro

Perform the Text to columns manually.

Turn off the macro recorder and look at what was recorded. You now have the
basic code you need.