Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 07-28-2019, 06:24 AM
DVS75 DVS75 is offline How to convert paragaraphs in a table into new columns? Windows 10 How to convert paragaraphs in a table into new columns? Office 2019
Novice
How to convert paragaraphs in a table into new columns?
 
Join Date: Jul 2019
Location: Saint Petersburg, Russia
Posts: 4
DVS75 is on a distinguished road
Default How to convert paragaraphs in a table into new columns?


I have a table like the one in the attachment (about hundred pages long), but I need to convert the text separated by paragraphs into separate columns.

Please let me know how I can do it.

Thank you!
Attached Images
File Type: png table.png (14.0 KB, 14 views)
Reply With Quote
  #2  
Old 07-28-2019, 04:50 PM
Guessed's Avatar
Guessed Guessed is offline How to convert paragaraphs in a table into new columns? Windows 10 How to convert paragaraphs in a table into new columns? Office 2016
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 3,969
Guessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant future
Default

On a copy of the file...

First do a Find and Replace
Find ^p
Replace with ^t

That will convert all the paragraph marks to tabs. Then select the table and go Table Tools Layout tab and choose Convert to Text. While that content is still selected, go to Insert > Table > Convert Text to Table
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia

Last edited by Guessed; 07-28-2019 at 11:51 PM.
Reply With Quote
  #3  
Old 07-28-2019, 10:52 PM
DVS75 DVS75 is offline How to convert paragaraphs in a table into new columns? Windows 10 How to convert paragaraphs in a table into new columns? Office 2019
Novice
How to convert paragaraphs in a table into new columns?
 
Join Date: Jul 2019
Location: Saint Petersburg, Russia
Posts: 4
DVS75 is on a distinguished road
Default

In my version of Word I had to use ^p to find paragraph breaks.


In order for the plan to work I had to first convert the existing table to text and then convert all the text into a new table.
Reply With Quote
  #4  
Old 07-28-2019, 11:50 PM
Guessed's Avatar
Guessed Guessed is offline How to convert paragaraphs in a table into new columns? Windows 10 How to convert paragaraphs in a table into new columns? Office 2016
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 3,969
Guessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant future
Default

You are correct. I mistyped the and will correct the earlier response.
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
How to convert paragaraphs in a table into new columns? How to convert document columns to excel spreadsheet davidjm Word 2 06-04-2018 11:03 PM
How to convert paragaraphs in a table into new columns? Macro to convert table to convert table into iCalendar file? Weboh Word VBA 5 12-10-2016 03:07 PM
convert columns into rows RayK Excel 2 02-09-2016 06:08 AM
convert list to columns Tuna425 Word 4 08-20-2013 01:25 PM
Word table - how do I append % symbol to each value in columns 3 & 4 of a table Dawsie Word 4 03-06-2013 12:33 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:22 PM.


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