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

Go to Data-Text to Columns-choose delimited, next, then check the box
beside Space, that should do it for you.
--
-John
Please rate when your question is answered to help us and others know what
is helpful.


"filo666" wrote:

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

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

"John Bundy" wrote:

Go to Data-Text to Columns-choose delimited, next, then check the box
beside Space, that should do it for you.
--
-John
Please rate when your question is answered to help us and others know what
is helpful.


"filo666" wrote:

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

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.

--
regards,
Tom Ogilvy


"filo666" wrote:

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

"John Bundy" wrote:

Go to Data-Text to Columns-choose delimited, next, then check the box
beside Space, that should do it for you.
--
-John
Please rate when your question is answered to help us and others know what
is helpful.


"filo666" wrote:

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