Forum Discussion
Word to Excel
Can you convert word files to excel files? Yes or no. If yes how. Thanks
The word file is all text data. Name, address, phone number, date, no formulas. This is a list of approximately 1600 customers for our small business. I would like to copy and paste the word files into the excel file. Typing all the names into the excel file, is what I'm trying avoid.
You can either try:
1. Copy all words from Word to Excel by using simple Ctrl + C => Ctrl + V. Then use Excel Text to Column function and exploring from there. (Data -> Text to Column)
2. Make a table in Word, clean all your data in Word (each value to corresponding place), then copy whole table to Excel.
Feel free to ask if you're still stuck.
1. Copy all words from Word to Excel by using simple Ctrl + C => Ctrl + V. Then use Excel Text to Column function and exploring from there. (Data -> Text to Column)
2. Make a table in Word, clean all your data in Word (each value to corresponding place), then copy whole table to Excel.
Feel free to ask if you're still stuck.
- Thanks, I will try your idea. I will let you know the outcome.
Steve