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.
Discover the Power of Microsoft Office This beginner-friendly guide reveals the expert tips and strategies you need to skyrocket your productivity and use Office 365 like a pro. Mastering software like Word, Excel, and PowerPoint is essential to be more efficient and advance your career. Simple lessons guide you through every step, providing the knowledge you need to get started. Check out Microsoft Office 365 For Beginners today!
In WordPerfect terminology, a split page allows you to put information side-by-side on opposite halves of the page. If ...
Discover MoreWant to get rid of information within a table, but not the table itself? Here's a guide to understanding the effects that ...
Discover MoreWhat do you do if you add numbered captions to an element of your document (such as tables) and Word skips a number? ...
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