Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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, |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
import excel data into existing excel report | Excel Worksheet Functions | |||
Protecting sheet disables import of extetrnal data in Excel 2003 | Excel Discussion (Misc queries) | |||
How do i copy columns of data in notepad into microsoft excel? | Excel Discussion (Misc queries) | |||
How do i copy columns of data in notepad into microsoft excel? | Excel Discussion (Misc queries) | |||
Fetching External Data from Excel | Excel Discussion (Misc queries) |