<

Word tables made with spaces - Cleanup!

Published on
9,719 Points
3,619 Views
1 Endorsement
Last Modified:
Approved
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: Word Table made with spacebar

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!
1
Ask questions about what you read
If you have a question about something within an article, you can receive help directly from the article author. Experts Exchange article authors are available to answer questions and further the discussion.
Get 7 days free