Sharon

Does anyone know if there is a setting somewhere in Excel where I
could paste each line of data onto one cell? I dont understand how
Excel sometimes pasted the data into multiple columns and sometimes
into 1 column.

Excel tries to help you by remembering the last set in DataText to Columns.

Sometimes it will split to columns because the last time you used that function
you had it set for delimited byspace.

Next time it will leave it one column because delimited by space was not left
over.

It is a crap-shoot unless you make sure beforehand that the settings are set to
"Fixed Width"

You can ensure that by first running something through using that setting.

Or do it in code when you copy from the DB.


Gord Dibben MS Excel MVP