coping cell contains to different cells

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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Blank Cells 3
HowTo: detect a cell contains an ArrayFormula in vba? 1
concatenated cell properties 2
Need to count cells in Column1 where each cell's row also hasspecified value in Column2 1
Populate cell with multiple non-blank text values 3
if the numbers in sequence 11
delete cell if part of cell contains 6

Top