coping cell contains to different cells

  • Thread starter Thread starter TK
  • Start date Start date
T

TK

I am running Excel 2007
If I have 3 words in cell A1 all separated by a blank space, how can I copy
the 1st word to A2, 2nd word to A3, and the 3rd word to cell A4...?
I have a 1,000 rows to do.
Thanks...
 
Back
Top