How to split cell content into rows by paragraph in word
I have a text in a single cell of table in Microsoft Office word image below that represents one cell of table in Microsoft Office Word
I want to split the cell into multiple rows by paragraph, such that outcome should be
1 Aaatika Arif Form–III
in a single table row and similarly all text rows visible in image should be shifted to their own table rows.
microsoft-word
add a comment |
I have a text in a single cell of table in Microsoft Office word image below that represents one cell of table in Microsoft Office Word
I want to split the cell into multiple rows by paragraph, such that outcome should be
1 Aaatika Arif Form–III
in a single table row and similarly all text rows visible in image should be shifted to their own table rows.
microsoft-word
Thanks @MátéJuhász for you timely and valuable feedback. I got the idea through your answer. This is really perfect if the rows required are only 4. Actual number is bigger like 150. I am expecting some way that should not need text pasting in separate rows manually. Like we do not need to cut and paste text into table cells when using "Convert Text to Table" option under "Insert (tab) > Table".
– Ahmed Naveed
May 16 '18 at 7:14
If you have only one cell in your table, then you can convert it to text, then back to table. If either that doesn't work, then I don't see any good solution:(
– Máté Juhász
May 16 '18 at 7:18
@MátéJuhász, given the number of paragraphs involved, that really is the best, most manageable solution and deserves to be given as an actual answer, I think.
– cnread
May 16 '18 at 7:31
@cnread: it works only if that's the only cells in the table (or only one column and all cells need to be splited).
– Máté Juhász
May 16 '18 at 7:39
add a comment |
I have a text in a single cell of table in Microsoft Office word image below that represents one cell of table in Microsoft Office Word
I want to split the cell into multiple rows by paragraph, such that outcome should be
1 Aaatika Arif Form–III
in a single table row and similarly all text rows visible in image should be shifted to their own table rows.
microsoft-word
I have a text in a single cell of table in Microsoft Office word image below that represents one cell of table in Microsoft Office Word
I want to split the cell into multiple rows by paragraph, such that outcome should be
1 Aaatika Arif Form–III
in a single table row and similarly all text rows visible in image should be shifted to their own table rows.
microsoft-word
microsoft-word
edited May 16 '18 at 6:24
Máté Juhász
14.4k63352
14.4k63352
asked May 16 '18 at 5:47
Ahmed NaveedAhmed Naveed
85
85
Thanks @MátéJuhász for you timely and valuable feedback. I got the idea through your answer. This is really perfect if the rows required are only 4. Actual number is bigger like 150. I am expecting some way that should not need text pasting in separate rows manually. Like we do not need to cut and paste text into table cells when using "Convert Text to Table" option under "Insert (tab) > Table".
– Ahmed Naveed
May 16 '18 at 7:14
If you have only one cell in your table, then you can convert it to text, then back to table. If either that doesn't work, then I don't see any good solution:(
– Máté Juhász
May 16 '18 at 7:18
@MátéJuhász, given the number of paragraphs involved, that really is the best, most manageable solution and deserves to be given as an actual answer, I think.
– cnread
May 16 '18 at 7:31
@cnread: it works only if that's the only cells in the table (or only one column and all cells need to be splited).
– Máté Juhász
May 16 '18 at 7:39
add a comment |
Thanks @MátéJuhász for you timely and valuable feedback. I got the idea through your answer. This is really perfect if the rows required are only 4. Actual number is bigger like 150. I am expecting some way that should not need text pasting in separate rows manually. Like we do not need to cut and paste text into table cells when using "Convert Text to Table" option under "Insert (tab) > Table".
– Ahmed Naveed
May 16 '18 at 7:14
If you have only one cell in your table, then you can convert it to text, then back to table. If either that doesn't work, then I don't see any good solution:(
– Máté Juhász
May 16 '18 at 7:18
@MátéJuhász, given the number of paragraphs involved, that really is the best, most manageable solution and deserves to be given as an actual answer, I think.
– cnread
May 16 '18 at 7:31
@cnread: it works only if that's the only cells in the table (or only one column and all cells need to be splited).
– Máté Juhász
May 16 '18 at 7:39
Thanks @MátéJuhász for you timely and valuable feedback. I got the idea through your answer. This is really perfect if the rows required are only 4. Actual number is bigger like 150. I am expecting some way that should not need text pasting in separate rows manually. Like we do not need to cut and paste text into table cells when using "Convert Text to Table" option under "Insert (tab) > Table".
– Ahmed Naveed
May 16 '18 at 7:14
Thanks @MátéJuhász for you timely and valuable feedback. I got the idea through your answer. This is really perfect if the rows required are only 4. Actual number is bigger like 150. I am expecting some way that should not need text pasting in separate rows manually. Like we do not need to cut and paste text into table cells when using "Convert Text to Table" option under "Insert (tab) > Table".
– Ahmed Naveed
May 16 '18 at 7:14
If you have only one cell in your table, then you can convert it to text, then back to table. If either that doesn't work, then I don't see any good solution:(
– Máté Juhász
May 16 '18 at 7:18
If you have only one cell in your table, then you can convert it to text, then back to table. If either that doesn't work, then I don't see any good solution:(
– Máté Juhász
May 16 '18 at 7:18
@MátéJuhász, given the number of paragraphs involved, that really is the best, most manageable solution and deserves to be given as an actual answer, I think.
– cnread
May 16 '18 at 7:31
@MátéJuhász, given the number of paragraphs involved, that really is the best, most manageable solution and deserves to be given as an actual answer, I think.
– cnread
May 16 '18 at 7:31
@cnread: it works only if that's the only cells in the table (or only one column and all cells need to be splited).
– Máté Juhász
May 16 '18 at 7:39
@cnread: it works only if that's the only cells in the table (or only one column and all cells need to be splited).
– Máté Juhász
May 16 '18 at 7:39
add a comment |
3 Answers
3
active
oldest
votes
- split cells
- Select the cell you need to split
- go to "table tools" - layout
- click "split cells"
- set desired number of columns / rows (1 / 4 in your case)
- click "ok"
- this will insert new rows, but keep text in the first one
before:
after:
- distribute text
- select the text you want to split
- right-click and cut (CTRL+X)
- select all the rows you want to fill
- right-click and paste (CTRL+V)
thank you so much. You have solved my problem by suggesting second option of "distribute text".
– Ahmed Naveed
May 16 '18 at 8:01
add a comment |
Although I usually use the Split Cells command, as Máté Juhász suggests, another way to do this is to use Word's Draw Table tool.
Select the table, or make sure that the cursor is somewhere inside it, and then, on the Table Tools > Layout tab, in the Draw group, click Draw Table.
Then just draw in horizontal lines between the paragraphs that you want to split into rows. Word will break the single cell into multiple rows.
Note, however, that the Draw Table tool is a bit fussy. If you don't draw the line in just the right place between paragraphs, you end up with extra rows or rows inserted between paragraphs other than the ones that you intended.
Tip: I always find that I need to basically draw right through the middle of the text in each paragraph to get the tool to work the way I want. So, to get the table to divide between paragraphs 1 and 2, draw through the middle of the line of text in paragraph 1. Then draw through the middle of the text in paragraph 2 to divide the table between paragraphs 2 and 3, and so on.
You'll probably also end up with extra space at the bottom of the last row, as shown below. In this case, just drag the bottom border upward until the extra space disappears. (Be sure to turn off the Draw Table tool first, either by clicking the button again or by pressing Esc.)
Update: I was assuming that your screenshot reflected the actual size of your tables. If, as you say, you're dealing with tables that have 150 paragraphs, this solution, which would otherwise be very quick (once you become accustomed to the tool), will obviously be too much work.
thank you so much for your effort to provide me the solution. You said rightly in update that you assumed that my screenshot reflected the actual size of table. But fact is that I selected only 4 lines to be shown in screenshot and actual are more than 4.
– Ahmed Naveed
May 16 '18 at 7:58
add a comment |
I had a similar problem, but one row with two columns, each of which had many paragraphs of text I wanted to split.
I selected and copied all text in both columns, then pasted it into a new blank Excel file, and it automatically split those paragraphs into rows. I then selected the cells in Excel and copied-and-pasted them into Word - that fixed the problem for me.
add a comment |
Your Answer
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "3"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f1323098%2fhow-to-split-cell-content-into-rows-by-paragraph-in-word%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
3 Answers
3
active
oldest
votes
3 Answers
3
active
oldest
votes
active
oldest
votes
active
oldest
votes
- split cells
- Select the cell you need to split
- go to "table tools" - layout
- click "split cells"
- set desired number of columns / rows (1 / 4 in your case)
- click "ok"
- this will insert new rows, but keep text in the first one
before:
after:
- distribute text
- select the text you want to split
- right-click and cut (CTRL+X)
- select all the rows you want to fill
- right-click and paste (CTRL+V)
thank you so much. You have solved my problem by suggesting second option of "distribute text".
– Ahmed Naveed
May 16 '18 at 8:01
add a comment |
- split cells
- Select the cell you need to split
- go to "table tools" - layout
- click "split cells"
- set desired number of columns / rows (1 / 4 in your case)
- click "ok"
- this will insert new rows, but keep text in the first one
before:
after:
- distribute text
- select the text you want to split
- right-click and cut (CTRL+X)
- select all the rows you want to fill
- right-click and paste (CTRL+V)
thank you so much. You have solved my problem by suggesting second option of "distribute text".
– Ahmed Naveed
May 16 '18 at 8:01
add a comment |
- split cells
- Select the cell you need to split
- go to "table tools" - layout
- click "split cells"
- set desired number of columns / rows (1 / 4 in your case)
- click "ok"
- this will insert new rows, but keep text in the first one
before:
after:
- distribute text
- select the text you want to split
- right-click and cut (CTRL+X)
- select all the rows you want to fill
- right-click and paste (CTRL+V)
- split cells
- Select the cell you need to split
- go to "table tools" - layout
- click "split cells"
- set desired number of columns / rows (1 / 4 in your case)
- click "ok"
- this will insert new rows, but keep text in the first one
before:
after:
- distribute text
- select the text you want to split
- right-click and cut (CTRL+X)
- select all the rows you want to fill
- right-click and paste (CTRL+V)
answered May 16 '18 at 6:43
Máté JuhászMáté Juhász
14.4k63352
14.4k63352
thank you so much. You have solved my problem by suggesting second option of "distribute text".
– Ahmed Naveed
May 16 '18 at 8:01
add a comment |
thank you so much. You have solved my problem by suggesting second option of "distribute text".
– Ahmed Naveed
May 16 '18 at 8:01
thank you so much. You have solved my problem by suggesting second option of "distribute text".
– Ahmed Naveed
May 16 '18 at 8:01
thank you so much. You have solved my problem by suggesting second option of "distribute text".
– Ahmed Naveed
May 16 '18 at 8:01
add a comment |
Although I usually use the Split Cells command, as Máté Juhász suggests, another way to do this is to use Word's Draw Table tool.
Select the table, or make sure that the cursor is somewhere inside it, and then, on the Table Tools > Layout tab, in the Draw group, click Draw Table.
Then just draw in horizontal lines between the paragraphs that you want to split into rows. Word will break the single cell into multiple rows.
Note, however, that the Draw Table tool is a bit fussy. If you don't draw the line in just the right place between paragraphs, you end up with extra rows or rows inserted between paragraphs other than the ones that you intended.
Tip: I always find that I need to basically draw right through the middle of the text in each paragraph to get the tool to work the way I want. So, to get the table to divide between paragraphs 1 and 2, draw through the middle of the line of text in paragraph 1. Then draw through the middle of the text in paragraph 2 to divide the table between paragraphs 2 and 3, and so on.
You'll probably also end up with extra space at the bottom of the last row, as shown below. In this case, just drag the bottom border upward until the extra space disappears. (Be sure to turn off the Draw Table tool first, either by clicking the button again or by pressing Esc.)
Update: I was assuming that your screenshot reflected the actual size of your tables. If, as you say, you're dealing with tables that have 150 paragraphs, this solution, which would otherwise be very quick (once you become accustomed to the tool), will obviously be too much work.
thank you so much for your effort to provide me the solution. You said rightly in update that you assumed that my screenshot reflected the actual size of table. But fact is that I selected only 4 lines to be shown in screenshot and actual are more than 4.
– Ahmed Naveed
May 16 '18 at 7:58
add a comment |
Although I usually use the Split Cells command, as Máté Juhász suggests, another way to do this is to use Word's Draw Table tool.
Select the table, or make sure that the cursor is somewhere inside it, and then, on the Table Tools > Layout tab, in the Draw group, click Draw Table.
Then just draw in horizontal lines between the paragraphs that you want to split into rows. Word will break the single cell into multiple rows.
Note, however, that the Draw Table tool is a bit fussy. If you don't draw the line in just the right place between paragraphs, you end up with extra rows or rows inserted between paragraphs other than the ones that you intended.
Tip: I always find that I need to basically draw right through the middle of the text in each paragraph to get the tool to work the way I want. So, to get the table to divide between paragraphs 1 and 2, draw through the middle of the line of text in paragraph 1. Then draw through the middle of the text in paragraph 2 to divide the table between paragraphs 2 and 3, and so on.
You'll probably also end up with extra space at the bottom of the last row, as shown below. In this case, just drag the bottom border upward until the extra space disappears. (Be sure to turn off the Draw Table tool first, either by clicking the button again or by pressing Esc.)
Update: I was assuming that your screenshot reflected the actual size of your tables. If, as you say, you're dealing with tables that have 150 paragraphs, this solution, which would otherwise be very quick (once you become accustomed to the tool), will obviously be too much work.
thank you so much for your effort to provide me the solution. You said rightly in update that you assumed that my screenshot reflected the actual size of table. But fact is that I selected only 4 lines to be shown in screenshot and actual are more than 4.
– Ahmed Naveed
May 16 '18 at 7:58
add a comment |
Although I usually use the Split Cells command, as Máté Juhász suggests, another way to do this is to use Word's Draw Table tool.
Select the table, or make sure that the cursor is somewhere inside it, and then, on the Table Tools > Layout tab, in the Draw group, click Draw Table.
Then just draw in horizontal lines between the paragraphs that you want to split into rows. Word will break the single cell into multiple rows.
Note, however, that the Draw Table tool is a bit fussy. If you don't draw the line in just the right place between paragraphs, you end up with extra rows or rows inserted between paragraphs other than the ones that you intended.
Tip: I always find that I need to basically draw right through the middle of the text in each paragraph to get the tool to work the way I want. So, to get the table to divide between paragraphs 1 and 2, draw through the middle of the line of text in paragraph 1. Then draw through the middle of the text in paragraph 2 to divide the table between paragraphs 2 and 3, and so on.
You'll probably also end up with extra space at the bottom of the last row, as shown below. In this case, just drag the bottom border upward until the extra space disappears. (Be sure to turn off the Draw Table tool first, either by clicking the button again or by pressing Esc.)
Update: I was assuming that your screenshot reflected the actual size of your tables. If, as you say, you're dealing with tables that have 150 paragraphs, this solution, which would otherwise be very quick (once you become accustomed to the tool), will obviously be too much work.
Although I usually use the Split Cells command, as Máté Juhász suggests, another way to do this is to use Word's Draw Table tool.
Select the table, or make sure that the cursor is somewhere inside it, and then, on the Table Tools > Layout tab, in the Draw group, click Draw Table.
Then just draw in horizontal lines between the paragraphs that you want to split into rows. Word will break the single cell into multiple rows.
Note, however, that the Draw Table tool is a bit fussy. If you don't draw the line in just the right place between paragraphs, you end up with extra rows or rows inserted between paragraphs other than the ones that you intended.
Tip: I always find that I need to basically draw right through the middle of the text in each paragraph to get the tool to work the way I want. So, to get the table to divide between paragraphs 1 and 2, draw through the middle of the line of text in paragraph 1. Then draw through the middle of the text in paragraph 2 to divide the table between paragraphs 2 and 3, and so on.
You'll probably also end up with extra space at the bottom of the last row, as shown below. In this case, just drag the bottom border upward until the extra space disappears. (Be sure to turn off the Draw Table tool first, either by clicking the button again or by pressing Esc.)
Update: I was assuming that your screenshot reflected the actual size of your tables. If, as you say, you're dealing with tables that have 150 paragraphs, this solution, which would otherwise be very quick (once you become accustomed to the tool), will obviously be too much work.
edited May 16 '18 at 7:44
answered May 16 '18 at 7:09
cnreadcnread
1,781248
1,781248
thank you so much for your effort to provide me the solution. You said rightly in update that you assumed that my screenshot reflected the actual size of table. But fact is that I selected only 4 lines to be shown in screenshot and actual are more than 4.
– Ahmed Naveed
May 16 '18 at 7:58
add a comment |
thank you so much for your effort to provide me the solution. You said rightly in update that you assumed that my screenshot reflected the actual size of table. But fact is that I selected only 4 lines to be shown in screenshot and actual are more than 4.
– Ahmed Naveed
May 16 '18 at 7:58
thank you so much for your effort to provide me the solution. You said rightly in update that you assumed that my screenshot reflected the actual size of table. But fact is that I selected only 4 lines to be shown in screenshot and actual are more than 4.
– Ahmed Naveed
May 16 '18 at 7:58
thank you so much for your effort to provide me the solution. You said rightly in update that you assumed that my screenshot reflected the actual size of table. But fact is that I selected only 4 lines to be shown in screenshot and actual are more than 4.
– Ahmed Naveed
May 16 '18 at 7:58
add a comment |
I had a similar problem, but one row with two columns, each of which had many paragraphs of text I wanted to split.
I selected and copied all text in both columns, then pasted it into a new blank Excel file, and it automatically split those paragraphs into rows. I then selected the cells in Excel and copied-and-pasted them into Word - that fixed the problem for me.
add a comment |
I had a similar problem, but one row with two columns, each of which had many paragraphs of text I wanted to split.
I selected and copied all text in both columns, then pasted it into a new blank Excel file, and it automatically split those paragraphs into rows. I then selected the cells in Excel and copied-and-pasted them into Word - that fixed the problem for me.
add a comment |
I had a similar problem, but one row with two columns, each of which had many paragraphs of text I wanted to split.
I selected and copied all text in both columns, then pasted it into a new blank Excel file, and it automatically split those paragraphs into rows. I then selected the cells in Excel and copied-and-pasted them into Word - that fixed the problem for me.
I had a similar problem, but one row with two columns, each of which had many paragraphs of text I wanted to split.
I selected and copied all text in both columns, then pasted it into a new blank Excel file, and it automatically split those paragraphs into rows. I then selected the cells in Excel and copied-and-pasted them into Word - that fixed the problem for me.
edited Jan 24 at 20:36
Mark Deven
577222
577222
answered Jan 24 at 16:44
Adam WarrenAdam Warren
1
1
add a comment |
add a comment |
Thanks for contributing an answer to Super User!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f1323098%2fhow-to-split-cell-content-into-rows-by-paragraph-in-word%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Thanks @MátéJuhász for you timely and valuable feedback. I got the idea through your answer. This is really perfect if the rows required are only 4. Actual number is bigger like 150. I am expecting some way that should not need text pasting in separate rows manually. Like we do not need to cut and paste text into table cells when using "Convert Text to Table" option under "Insert (tab) > Table".
– Ahmed Naveed
May 16 '18 at 7:14
If you have only one cell in your table, then you can convert it to text, then back to table. If either that doesn't work, then I don't see any good solution:(
– Máté Juhász
May 16 '18 at 7:18
@MátéJuhász, given the number of paragraphs involved, that really is the best, most manageable solution and deserves to be given as an actual answer, I think.
– cnread
May 16 '18 at 7:31
@cnread: it works only if that's the only cells in the table (or only one column and all cells need to be splited).
– Máté Juhász
May 16 '18 at 7:39