Written by Allen Wyatt (last updated April 29, 2022)
This tip applies to Word 2007, 2010, 2013, 2016, 2019, and 2021
It is not uncommon in many word processors to format tables with spaces. Enough spaces are inserted between each column to align the first letter of each column. Word, however, includes a table editor, which provides more flexibility in formatting and working with tables. Converting ASCII tables originally formatted with spaces to Word tables can be time consuming. The following VBA macro will do the formatting automatically. It assumes that each line represents a different row in the table, and that anything beyond a single space represents a division between columns.
Sub SpacesToTable With Selection.Find .ClearFormatting .Replacement.ClearFormatting .Text = " {2,}" .Replacement.Text = "^t" .Forward = True .Wrap = wdFindStop .Format = False .MatchCase = False .MatchWholeWord = False .MatchAllWordForms = False .MatchSoundsLike = False .MatchWildcards = True End With Selection.Find.Execute Replace:=wdReplaceAll Selection.ConvertToTable _ Separator:=wdSeparateByTabs, _ Format:=wdTableFormatNone End Sub
Before running the macro, select the text you want to convert. When you run this macro, you will get the same thing you would get if you clicked the Table tool (Insert tab of the ribbon) and selected Convert Text to Table. This means your columns might look funky; they will definitely need to be resized. But the hard work of getting rid of all the spaces has been done for you.
Note:
WordTips is your source for cost-effective Microsoft Word training. (Microsoft Word is the most popular word processing software in the world.) This tip (12214) applies to Microsoft Word 2007, 2010, 2013, 2016, 2019, and 2021. You can find a version of this tip for the older menu interface of Word here: Formatting an ASCII Table with Spaces.
Comprehensive VBA Guide Visual Basic for Applications (VBA) is the language used for writing macros in all Office programs. This complete guide shows both professionals and novices how to master VBA in order to customize the entire Office suite for their needs. Check out Mastering VBA for Office 2010 today!
If you need to quickly display the Column tab of the Table Properties dialog box, here are some handy tricks you can use. ...
Discover MoreWord allows you to format your text using different languages. If you are working with a right-to-left language, you may ...
Discover MoreNeed a quick shortcut to jump to the top or bottom of a table column? Here's the two shortcuts you are searching for.
Discover MoreFREE SERVICE: Get tips like this every week in WordTips, a free productivity newsletter. Enter your address and click "Subscribe."
2022-05-04 12:43:25
James
This is a tip I have needed, for I often copy columnar tables from webpages and paste them into Word. But then the struggle begins to clean them up!
What would be useful Allen is How To cut 'n paste your macro above into the macro editor, instead of laboriously typing it in. I tried cut 'n paste and it created a macro that pasted in the VBA text, instead of running it.
I found a youtube video that demonstrates this, but with little explanatory comment.
I love your travel videos. Quality work.
Have you considered also a Word Tips channel on youtube?
Got a version of Word that uses the ribbon interface (Word 2007 or later)? This site is for you! If you use an earlier version of Word, visit our WordTips site focusing on the menu interface.
Visit the WordTips channel on YouTube
FREE SERVICE: Get tips like this every week in WordTips, a free productivity newsletter. Enter your address and click "Subscribe."
Copyright © 2025 Sharon Parq Associates, Inc.
Comments