Excel text to word as paragraphs, not table.

Guessed · #1 10-05-2020, 02:52 PM

I would do the normal copy and paste so you do get it as a Word table with the formatting intact. Then select the table and choose Convert to Text on the Table Tools > Layout ribbon tab.

Andersn2 · #2 10-05-2020, 03:49 PM

Thank you. That's simpler than I thought.
I'll try it.

Do you think this will preserve the bold/not bold formatting?

Thank you!

EricF · #3 10-05-2020, 05:11 PM

Quote:

Originally Posted by Andersn2

Do you think this will preserve the bold/not bold formatting?

You may lose the formatting within cells if your default Paste is set to "Keep Text Only". To keep the formatting, right-click and choose Paste Options > Keep source formatting.

You can change the default (i.e. what happens when you use Ctrl-v) to one of the several other paste options by using the Word Options > Advanced dialog; "Cut, copy, and paste" section.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Pass each of the rows from Excel to Word rtf in paragraphs in established order	Visor	Word VBA	5	06-30-2020 02:19 AM
Returns in Word table text become multiple rows when pasted in Excel	blorence	Word Tables	8	01-23-2019 01:57 PM
Macro to append text to end of paragraphs/lines where target text is found.	moorea21	Word VBA	8	06-20-2018 12:52 AM
a table pasted in word from excel is not similar to the original table in excel	Mukapa	Word Tables	1	01-18-2016 07:31 AM
Pasting text from Excel cell into word without creating a table, and keeping the in-cell formatting	hanvyj	Excel Programming	0	08-28-2015 01:15 AM