Sorry Max maybe I didn't explain myself very well

What I want is 1 column with data for column A column B column C etc in 1
column but not merged. I realise I can cut and paste each columns data and
add it to the bottom of the column I want it in but I need a quick formula as
it would take a long time with the amount of data I have.

"Max" wrote:

To join text from cols A and B (assumed in row1 down) in say, col C, try
something like this in C1: =TRIM(A1)&" "&TRIM(B1)
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"stelee" wrote in message
...
I am trying to find a way of combining text from multiple columns into 1
large column in Microsoft Excel 2000 and have tried the consolidate
function
but it does not work. Please can someone help.