ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Word to Excel (https://www.excelbanter.com/excel-discussion-misc-queries/124068-word-excel.html)

SuzyQ

Word to Excel
 
how do you save word data to excel so each piece of data is in it's own cell?

Sean Timmons

Word to Excel
 
If you have the data in Word as tables, it will put the data into individual
cells.

Or, if you have data separated by tabs, it will separate.

Or, if the data is separated by, say commas, you can paste into one cell in
Excel, go to Data-Text to Columns Select Delimited, check off comma, and it
will break it up for you.

"SuzyQ" wrote:

how do you save word data to excel so each piece of data is in it's own cell?



All times are GMT +1. The time now is 08:33 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com