Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 10-05-2020, 10:15 AM
Andersn2 Andersn2 is offline Excel text to word as paragraphs, not table. Windows 7 64bit Excel text to word as paragraphs, not table. Office XP
Novice
Excel text to word as paragraphs, not table.
 
Join Date: May 2012
Posts: 23
Andersn2 is on a distinguished road
Default Excel text to word as paragraphs, not table.

I have data consisting of thousands of rows all in a single excel column.

I need to move this data into Word but not as a Word table. Just as text.

Each excel row should appear in Word as a separate paragraph.

Each excel row contains its first word or two formatted as bold followed by a period. After that period, all the text in that row is formatted as not bold. This formatting needs to be retained during the transfer.



Can this be done? How?

Thanks.
Reply With Quote
  #2  
Old 10-05-2020, 02:52 PM
Guessed's Avatar
Guessed Guessed is offline Excel text to word as paragraphs, not table. Windows 10 Excel text to word as paragraphs, not table. Office 2016
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 1,935
Guessed is a name known to allGuessed is a name known to allGuessed is a name known to allGuessed is a name known to allGuessed is a name known to allGuessed is a name known to all
Default

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.
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote
  #3  
Old 10-05-2020, 03:49 PM
Andersn2 Andersn2 is offline Excel text to word as paragraphs, not table. Windows 7 64bit Excel text to word as paragraphs, not table. Office XP
Novice
Excel text to word as paragraphs, not table.
 
Join Date: May 2012
Posts: 23
Andersn2 is on a distinguished road
Default

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!
Reply With Quote
  #4  
Old 10-05-2020, 05:11 PM
EricF EricF is offline Excel text to word as paragraphs, not table. Windows 10 Excel text to word as paragraphs, not table. Office 2019
Novice
 
Join Date: Oct 2020
Location: Canada
Posts: 2
EricF is on a distinguished road
Default

Quote:
Originally Posted by Andersn2 View Post
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.
Reply With Quote
  #5  
Old 10-05-2020, 06:54 PM
Andersn2 Andersn2 is offline Excel text to word as paragraphs, not table. Windows 7 64bit Excel text to word as paragraphs, not table. Office XP
Novice
Excel text to word as paragraphs, not table.
 
Join Date: May 2012
Posts: 23
Andersn2 is on a distinguished road
Default

Thank you.
You are wonderful.
I appreciate the help.
Reply With Quote
  #6  
Old 10-06-2020, 09:17 AM
Andersn2 Andersn2 is offline Excel text to word as paragraphs, not table. Windows 7 64bit Excel text to word as paragraphs, not table. Office XP
Novice
Excel text to word as paragraphs, not table.
 
Join Date: May 2012
Posts: 23
Andersn2 is on a distinguished road
Default

Quote:
Originally Posted by Andersn2 View Post
Thank you.
You are wonderful.
I appreciate the help.
Tried it. Worked perfectly.
(I did not know that a table could be coverted to text....)

Thank you.

Question:
In my Word 2002 text can only be put into 4 columns. Is it possible to:
1. Have 5 or more columns per page?
2. Modify the default space width between the columns?

Thank you.

I have Word 2007 installed too if that makes a difference. I just use Word 2002 because I prefer its menu structure.
Reply With Quote
  #7  
Old 10-06-2020, 05:20 PM
Guessed's Avatar
Guessed Guessed is offline Excel text to word as paragraphs, not table. Windows 10 Excel text to word as paragraphs, not table. Office 2016
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 1,935
Guessed is a name known to allGuessed is a name known to allGuessed is a name known to allGuessed is a name known to allGuessed is a name known to allGuessed is a name known to all
Default

I'm using current versions of Word and I can add more than 5 columns to a section layout. I don't recall if Word 2002 even exists in Windows (I thought it jumped from 2000 to 2003), nor whether it is limited to 5 columns maximum.

I suspect it is more likely that the column count is limited by the size of the spaces between columns. You should be able to reduce those column gaps in the same column settings dialog.
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote
  #8  
Old 10-06-2020, 07:33 PM
Andersn2 Andersn2 is offline Excel text to word as paragraphs, not table. Windows 7 64bit Excel text to word as paragraphs, not table. Office XP
Novice
Excel text to word as paragraphs, not table.
 
Join Date: May 2012
Posts: 23
Andersn2 is on a distinguished road
Default

Thank you.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel text to word as paragraphs, not table. 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
Excel text to word as paragraphs, not table. Returns in Word table text become multiple rows when pasted in Excel blorence Word Tables 8 01-23-2019 01:57 PM
Excel text to word as paragraphs, not table. 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

Other Forums: Access Forums - Senior Forums

All times are GMT -7. The time now is 01:33 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2020, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2020 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft