Nice table. Huge mess.
Maybe this was something you created way back before you figured out tabs or a document you received from someone else. Either way, using the spacebar to separate the columns resulted in a mess. Trying to convert text to table results in hundreds of columns or hundreds of rows (depending on the separator you choose). The fastest way to clean this up? Search and destroy.
If you aren’t sure what I’m talking about, click the Show/Hide ¶ to see all those lovely spaces:
1. Tabs
Begin by setting up tabs. If you can’t see the ruler and tab button…
a. Word 2007/2010 – Click the View Tab and check the Ruler checkbox in the Show Group.
b. Word 2003 – On the View Menu, select Ruler.
2.
At the left edge of the window, above the Vertical Ruler, you’ll see a button, probably showing what looks like a capital L. It’s actually the Left Tab button. Clicking this button repeatedly will toggle it to Centered, Right, Decimal, and Line tabs. In Word 2007/2010, it also toggles to set the indents. For now, we’re just going to use the Left Tab.
3.
Select all the text in your messy table. BTW, if you move into the left margin area of your page, your mouse becomes an arrow that points NorthEast, toward 1:00 on a clockface, you get the idea. Click and drag straight down to select all the text to the right of the mouse arrow.
4.
Click on the Ruler to set your tabs, roughly using the columns of text to guide you. Setting tabs like this removes all the default tabs to the left of your set tab so you won’t have to tab-tab-tab to move to the next column.Now we’re ready to search and destroy spaces. Leave the table selected. We don’t want to replace all the spaces in your document, only the ones in this table.
1. Find
In the Find/Replace dialog box, we’re going to search for two spaces. So in the Find field, tap the spacebar twice.
2. Replace
In the Replace field, tap the spacebar once. (We could replace the two spaces with nothing and delete them altogether, but without counting spaces, we could end up with zero spaces and nothing to find to replace with tabs, so trust me on this.)
3.
Click Replace All. A dialog box will pop up telling you Word has made a gazillion replacements and ask if you want to search the remainder of the document. JUST SAY NO. This is a controlled burn.
4.
Click Replace All again. Remember to click NO when asked if you want to search the rest of the document. Repeat this process UNTIL you see two spaces (those dots!) between your columns. Don’t do that last replacement because you don’t want to get to the point that you’re replacing a single space with a tab (especially if there are spaces within the column text).
5. Insert Tabs
Now, in the Replace field, click anywhere in that big white field area and tap the BACKSPACE to delete the space that was there. Type ^t (this is the formatting information for a tab).
6.
Click Replace All.You might have a little bit of tweaking to do, but now you have a nicely formatted tabbed table. If you want to convert it to a true Word table, leave the text selected…
Word 2007/2010: Go to the Insert Tab. Click the Arrow beneath the Tables button. Choose the Convert Text to Table command. If you deselected your table, this option won’t be visible.
Word 2003: Go to the Tables Menu. Select Convert…
Look at "More Articles From NerdyWoman" (below) or Stay tuned! I’ve got more tricks to share with you!
Comments (6)
Author
Commented:As I said in Step 3: "Repeat this process UNTIL you see two spaces (those dots!) between your columns. Don’t do that last replacement because you don’t want to get to the point that you’re replacing a single space with a tab (especially if there are spaces within the column text)."
As for copying the table to Excel, that's over-engineering the project, isn't it?
Commented:
The attached screen shot shows why I maintain that you cannot reliably know whether the "space-space to space" replaces will reduce to just two spaces.
As for using Excel, yes, it is perhaps over-engineering! On the other hand, many users have both products, and if one has a very large table to convert, Excel may be a more expedient solution.
Author
Commented:As for Excel...while most users have both products, people who use Word extensively don't necessarily feel as comfortable with Excel.
Commented:
I think most EE readers find the full threads of article quite useful, so I added my comment because I could see a potential flaw. I intended it only as a constructive critique. Your procedure will work for some tables, but not all -- and if it failed for an EE reader of your article, my comment might help them figure out why.
I take your point about some users not being comfortable with Excel. However, it is a valid alternative method that could be more appropriate for users with extensive tables and a knowledge of Excel. I don't think mentioning it takes away from your article at all.
Author
Commented:View More