cut and paste paragraph separately into one column

[FrecklePaw]

I've got a huge chunk of paragraph text in MS Word with individual items separated by a comma that I want to cut and paste into one column in Excel. How can I do this?

e.g. how it looks in Word:

word, word, word, word, word, word, word, word, word, word, word,
word, word, word, word, etc.

How I need it to look in Excel:

[cell 1] word
[cell 2] word
[cell 3] word

all in one column

FP

[HansV]

Option 1:

Select the text in Word.
Press Ctrl+H to activate the Replace dialog.
Enter a comma followed by a space in the 'Find what' box.
Enter ^p in the 'Replace with' box.
Click 'Replace All'.
Answer No to the question whether to continue with the rest of the document.
Copy the text.
Paste into Excel.
You can now go back to Word and click Undo or press Ctrl+Z to restore the text to its original version.

Option 2:

Copy and paste the text into a single cell in Excel.
On the Data tab of the ribbon, click Text to Columns.
Select Delimited, then click Next >.
Tick the check boxes for both Space and Comma.
Click Finish.
You now have the words in one row.
Select and copy them.
Click elsewhere.
Click the lower half of the Paste button and select the Transpose option.

S0321.png

[FrecklePaw]

Thanks Hans! :)