Cut and paste text into table

FrecklePaw
2StarLounger
Posts: 130
Joined: 12 Aug 2020, 08:40

Cut and paste text into table

Post by FrecklePaw »

Hi everyone, I've got a table template that I want to use for inserting some text that I have. It's a document with text from a meeting that has been transcribed with a few people talking - the document is helpfully set out with each speaker on a new line. What I need to do is use this table to insert the text, but I want the text for each speaker (that's on a new/separate line) inserted into the table in a new cell of its own (as shown below) to separate them. How can I do this so I can just cut and paste it over and the text will appear for each speaker in the boxes of the table as shown in the attachment?
You do not have the required permissions to view the files attached to this post.

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

Re: Cut and paste text into table

Post by HansV »

Let's say you have 10 paragraphs of text.
Select and cut them (Ctrl+X).
Select 10 cells in a column of the table, then paste (Ctrl+V).
Each paragraph will end up in its own cell.
Best wishes,
Hans

FrecklePaw
2StarLounger
Posts: 130
Joined: 12 Aug 2020, 08:40

Re: Cut and paste text into table

Post by FrecklePaw »

Hi Hans, the whole document itself is quite lengthy, around 49 pages or so, and I'm unsure exactly how many columns I'd need to select - is there a way when you don't know the number to be able to insert each on its own cell within the table?

FrecklePaw
2StarLounger
Posts: 130
Joined: 12 Aug 2020, 08:40

Re: Cut and paste text into table

Post by FrecklePaw »

HansV wrote:
09 Jun 2021, 14:48
Let's say you have 10 paragraphs of text.
Select and cut them (Ctrl+X).
Select 10 cells in a column of the table, then paste (Ctrl+V).
Each paragraph will end up in its own cell.
Hi Hans, the whole document itself is quite lengthy, around 49 pages or so, and I'm unsure exactly how many columns I'd need to select - is there a way when you don't know the number to be able to insert each on its own cell within the table?

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

Re: Cut and paste text into table

Post by HansV »

Instead of pasting into the table, you could select the paragraphs, select Insert > Insert Table > Convert Text to Table, then insert columns to the left.
Best wishes,
Hans

FrecklePaw
2StarLounger
Posts: 130
Joined: 12 Aug 2020, 08:40

Re: Cut and paste text into table

Post by FrecklePaw »

ok that might suit better. do you know how to achieve the same format of table as in the picture?

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

Re: Cut and paste text into table

Post by HansV »

Select the table (for example by pressing Alt+Num 5).
Activate the Design tab of the ribbon under Table Tools.
Click Borders > Borders and Shading...
Scroll down the Style list and select the double line.
Click All, then click OK.

S0494.png
You do not have the required permissions to view the files attached to this post.
Best wishes,
Hans

FrecklePaw
2StarLounger
Posts: 130
Joined: 12 Aug 2020, 08:40

Re: Cut and paste text into table

Post by FrecklePaw »

HansV wrote:
09 Jun 2021, 15:14
Instead of pasting into the table, you could select the paragraphs, select Insert > Insert Table > Convert Text to Table, then insert columns to the left.
Hi Hans, this didn't work - it pasted the text but all in one cell. How can I get it so that each time there is a paragraph break it creates a new cell when I paste the text?

e.g.

speaker one - paragraph text blah blah blah

speaker two - paragraph text blah blah blah

speaker three - paragraph text blah blah blah

etc

Sorry if I wasn't clear before! I don't really know how or if this will work actually! See below of what I want it to look like: (I will be manually inserting the speaker names into the second column):
You do not have the required permissions to view the files attached to this post.

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

Re: Cut and paste text into table

Post by HansV »

Select the paragraphs.
On the Insert tab of the ribbon, click Table > Convert Text to Columns...

S0495.png

The dialog should look like this:

S0496.png

Just click OK. If it doesn't work: are there really paragraph breaks, or are they actually manual line breaks?

(I'll be away for a couple of hours)
You do not have the required permissions to view the files attached to this post.
Best wishes,
Hans

FrecklePaw
2StarLounger
Posts: 130
Joined: 12 Aug 2020, 08:40

Re: Cut and paste text into table

Post by FrecklePaw »

It has worked - I think I wasn't following the original instructions carefully and now it is better - thank you, apologies for my error. This is great, thank you.