| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
import data to specific columns
Hi- I'd like to import the data in my tab-separated text file into *certain* columns of my spreadsheet. Excel imports the data into adjacent columns, but is there a way to import into non-adjacent columns; e.g., import data into columns A, D, and G? Thanks. -- marlea ------------------------------------------------------------------------ marlea's Profile: http://www.excelforum.com/member.php...o&userid=26209 View this thread: http://www.excelforum.com/showthread...hreadid=395159 |
|
#2
|
|||
|
|||
|
How about importing them to a different worksheet, then copying the values where
you want. marlea wrote: Hi- I'd like to import the data in my tab-separated text file into *certain* columns of my spreadsheet. Excel imports the data into adjacent columns, but is there a way to import into non-adjacent columns; e.g., import data into columns A, D, and G? Thanks. -- marlea ------------------------------------------------------------------------ marlea's Profile: http://www.excelforum.com/member.php...o&userid=26209 View this thread: http://www.excelforum.com/showthread...hreadid=395159 -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I import external data populate rows instead of columns. | Excel Discussion (Misc queries) | |||
| How do I import formmail data to a custom excel template? | Excel Worksheet Functions | |||
| Import Data into same cell | Excel Discussion (Misc queries) | |||
| Automatic Data Import | Excel Discussion (Misc queries) | |||
| Pulling data from 1 sheet to another | Excel Worksheet Functions | |||
Linear Mode
