Cut and paste text into table
-
- 2StarLounger
- Posts: 130
- Joined: 12 Aug 2020, 08:40
Cut and paste text into table
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.
-
- Administrator
- Posts: 78474
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Cut and paste text into table
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.
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
Hans
-
- 2StarLounger
- Posts: 130
- Joined: 12 Aug 2020, 08:40
Re: Cut and paste text into table
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?
-
- 2StarLounger
- Posts: 130
- Joined: 12 Aug 2020, 08:40
Re: Cut and paste text into table
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?
-
- Administrator
- Posts: 78474
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Cut and paste text into table
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
Hans
-
- 2StarLounger
- Posts: 130
- Joined: 12 Aug 2020, 08:40
Re: Cut and paste text into table
ok that might suit better. do you know how to achieve the same format of table as in the picture?
-
- Administrator
- Posts: 78474
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Cut and paste text into table
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.
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.
You do not have the required permissions to view the files attached to this post.
Best wishes,
Hans
Hans
-
- 2StarLounger
- Posts: 130
- Joined: 12 Aug 2020, 08:40
Re: Cut and paste text into table
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.
-
- Administrator
- Posts: 78474
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Cut and paste text into table
Select the paragraphs.
On the Insert tab of the ribbon, click Table > Convert Text to Columns...
The dialog should look like this:
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)
On the Insert tab of the ribbon, click Table > Convert Text to Columns...
The dialog should look like this:
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
Hans
-
- 2StarLounger
- Posts: 130
- Joined: 12 Aug 2020, 08:40
Re: Cut and paste text into table
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.