Is there a way to convert a table from MS Word into an Excel spreadsheet?

Factual Questions
1

I’ve got a table in Word that is a mixture of text and numbers. I thought the numbers would be stable, but I’m now having to update and change them, including totals. I’d prefer to convert rather than retyping it all, if that’s possible.

2

Word table to Excel should copy and paste without issue.

3

Thanks! That worked.

Supplemental question: is there a way to add spaces before and after the text, within the cell? They’re mainly defaulting to single line space, which is very cramped.

But some are having spaces within the cell, when the text is wrapping into 2 or 3 lines within the cell.

4

I’m not sure what you are asking but, if you need more space in a cell, you can go to the top of the column in which the cell is located, hold your mouse pointer over the dividing line, hold down the left mouse button, and drag it to the right and widen it as much as you like.

5

Sorry, I don’t use Excel very much so not good at explaining, but I appreciate comments!

I’ll try and do a visual. Here’s what it looks like

Short item 1
Short item 2
Much longer item 3 that wraps to

a second line in the cell with a space
Short item 4
Short item 5

What I’d like it to look like is:

Short item 1

Short item 2

Much longer item 3 that wraps to
a second line in the cell without space

Short item 4

Short item 5

6
  • right-click on a group of cells
  • select Format Cells
  • go to Alignment tab
  • go to Indent control
  • set value to 1
7

And if you’re talking about vertical spacing, select a row (or multiple rows) and drag the line between row numbers down to increase the row size. You can also adjust the row height from the toolbar - on the Home bar in the Cells group, select Format | Cell Size | Row Height.

If you want to center the text within the row, there is a button on the home tab for vertical alignment. Click the one to middle-align the text.

8

Thanks for the comments, everyone; appreciated.

It looks like the hanging indents I used in the Word table are screwing up some entries but not others in Excel. The data all came through. Looks like I may need to use the format / row height button and the alignment option to make them all look consistent.

9

If you don’t have a whole lot of entries, you could manually edit each cell in the spreadsheet to get rid of troublesome formatting.

10

That’s what I did. Most of the entries were just one line, so didn’t need special formatting. It was the ones that wrapped around onto a second line that needed more space.

Thanks to everyone for their comments. I’m happy with the result.