Import text file to a SINGLE ROW?

[robazefa]

How do I import text into a single row in excel?
So far, I have tried the following in Excel 2002 SP3

data>import external data > import data > delimited> tap and colon to

seperate the data

I get data that is placed in a similar format to the text file, in
several columns and several rows, but I need all of the data in
seperate columns within the same row. How do I do this in excel?

Thanks,
Robazefa

 

[Bryan Hessey]

Hi,

Apart from editing your import file and removing CR/LF character
before you import, a possible option is to re-arrange your data afte
the import.

Assuming you have 38 rows of data, and that row 39 onwards is blank
then in A39 the formula

=IF(OFFSET(A$1,INT((ROW()-INT(ROW()/39)*39)),INT(ROW()/39)-1)="","",OFFSET(A$1,INT((ROW()-INT(ROW()/39)*39)),INT(ROW()/39)-1))

formula dragged downwards will copy all data to the A column where yo
can then Copy & (to a seperat sheet) Paste-Special = Values to fix th
data.

You can then use Transpose on that data to spread it across the column
, however, there are only 256 columns, so you cannot use this for bul
items.

Hope this helps