How to Convert Word to Excel
If you need to move a list or table of data from Word into Excel, you don't have to copy and paste each individual piece of information into its own cell in the spreadsheet. By properly formatting your Word document first, you can easily import the entire document into Excel with just a few clicks.
Steps Edit
Method One of Two:
.
- Click Replace All . You'll notice that the entries may combine themselves, but that's not a concern right now as long as the delimiting character is in the right place (between each entry)
(or whatever character you chose originally) into the Find field.
- Enter ^p into the Replace field.
- Click Replace All . This will break your entries back into individual groupings separated by the commas.
Method Two of Two:
Converting a Table Edit
Community Q&A
Related wikiHows
Insert a Line in Word
Add Font in Microsoft Word
Add Backgrounds in Word
Remove the 'Read Only' Status on MS Word Documents
Insert Equations in Microsoft Word
Rotate Text in Microsoft Word
Remove a Blank Page in Word
Add a Digital Signature in an MS Word Document