Can I import data into columns in Excel ?
I'm new at this - and need a little help troubleshooting!
I need to import data from a number of (MS Word) forms into Excel 2003. I am able to do this but the problem is that the data in each form exceeds the number of columns available. Is there a way to import the data set into a column as opposed to a row? If not - any other suggestions? Thank you in advance, |
Can I import data into columns in Excel ?
"Nickie" wrote in message
... I'm new at this - and need a little help troubleshooting! I need to import data from a number of (MS Word) forms into Excel 2003. I am able to do this but the problem is that the data in each form exceeds the number of columns available. Is there a way to import the data set into a column as opposed to a row? If not - any other suggestions? Tackling the problem from the Excel end, you could try the 2007 beta to allow more columns, but take note of all the warnings about beta versions. Looking at it from the Word end, you could use Word (or another editor) to change the field separator to a record separator. -- David Biddulph |
All times are GMT +1. The time now is 07:32 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com