cut and paste paragraph separately into one column

FrecklePaw
Lounger
Posts: 38
Joined: 12 Aug 2020, 08:40

cut and paste paragraph separately into one column

Post by 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

User avatar
HansV
Administrator
Posts: 71216
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: cut and paste paragraph separately into one column

Post by 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
You do not have the required permissions to view the files attached to this post.
Regards,
Hans

FrecklePaw
Lounger
Posts: 38
Joined: 12 Aug 2020, 08:40

Re: cut and paste paragraph separately into one column

Post by FrecklePaw »

Thanks Hans! :)