View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
John Bundy John Bundy is offline
external usenet poster
 
Posts: 772
Default An easy question

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