KEMBAR78
Word to Excel Table Formatting Guide | PDF
Scribd
Upload
1K views1 page

Word to Excel Table Formatting Guide

The document provides instructions for converting a table from Word to Excel by replacing certain special characters. It involves using the Find and Replace tool to change line breaks in Word to paragraph symbols, copying the table, and then replacing paragraph symbols with line breaks in Excel. The process allows the table data to be properly formatted when pasted into Excel.

Uploaded by

voccubd
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
1K views1 page

Word to Excel Table Formatting Guide

The document provides instructions for converting a table from Word to Excel by replacing certain special characters. It involves using the Find and Replace tool to change line breaks in Word to paragraph symbols, copying the table, and then replacing paragraph symbols with line breaks in Excel. The process allows the table data to be properly formatted when pasted into Excel.

Uploaded by

voccubd
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 1

39

You'll have to do a bit of character replacement. It's a pretty simple fix.

In Word:

1. Select your entire table in Word.


2. Open the "Find and Replace" dialog (e.g., by typing Ctrl + H ).
3. In the "Find what" field, enter ^l . This will select all line breaks.
You may select paragraph breaks by entering ^p .
4. In the "Replace with" field, enter ^v .
This is a shortcut for the paragraph symbol ¶, also known as a "pilcrow".
You may want to replace paragraph marks with two pilcrows for ease in replacement
later.
5. Click "Replace All".
6. Copy the table data to the clipboard.

In Excel:

1. Paste your table in the desired location in Excel.


2. With the tabular data selected, open the "Find and Replace" dialog (again, Ctrl + H
works).
3. In the "Find what" field, enter the following Alt code: Alt + 0 1 8 2 . A pilcrow
appears.
To enter an Alt code, hold down the Alt key as you type the digits on the numeric
keypad. It may help to have Num Lock on.
4. In the Replace field, enter the following Alt code: Alt + 0 0 1 0 .
This code enters in a single line break. Nothing appears, though your cursor may
change.
5. Click "Replace All".

You might also like