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

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