This example is different because you have multiple spaces. In addition, you might want to split Column B into Street Number and Street. Then, you could do a similar extraction process to separate the city. The easiest way is to use Excel to convert text to columns. Excel offers several functions to parse text.įor example, you might want to split Column A into two fields representing First Name and Last Name. However, you may want to adjust the results to suit your needs. In this example, our contact records were pretty uniform. Pin Pasted address entries from Word Tweaking the Excel Addresses In cell A1, press Ctrl + V and paste your data.To get your data into Excel, highlight the table and press Ctrl + C.If you don’t want the borders to show, you can go to Table Design and choose No borders.

Keep the default entry for Separate text at Paragraphs.

If you have a blank line between records, add 1.

In the Number of columns: field, select the number of lines that make one record.

From Word’s Table menu, select Convert Text to Table….

Copy and paste the contacts or text you need to convert to a new document.

Excel tables are a special feature that provides additional benefits. I should mention that although the word “table” is in both Microsoft programs, we’re not copying the data to an Excel Table. The Word table we’ll create has one row for each contact. The reason we opted for a Word table is that the format is similar to an Excel spreadsheet.

Convert text into table in word