I think the problem is with your input data. the data may have been created
on a unix system that uses a different Line feed. Your problem may be all
the data is ending up on one line because it is not recognizing the carriage
return. If this is the case I have a better solution which is to read the
data into the worksheet using a macro that will recognized the UNIX carriage
return.

"J" wrote:

I am importing CSV records from a sales management application and the
information, when imported, hits the sheet in the columns and each range
needs to be moved into the correct columns. (This imported information is of
a different size each time it is imported. )

Also, there will be several ranges of records that will have to be moved
under the same identified column.

Example:

move I2 thru M2 to D2
move N2 thru R2 to D3
move S2 thru W2 to D4 (and so on until it finds the last record with the
same import code)

I have identified the columns that this information needs to be moved into,
however I do not know the formula or code to tell it to do this?

Can anyone help me? Thanks, J.