Forgot to mention earlier that you could just copy C1 down to combine
correspondingly for all the other rows in cols A and B ..

Anyway, if what you want is to put text from col B "below" text from col A
in col C, then you could try this:

Select and format col C to wrap text first
(Format Cells Alignment tab Check "Wrap text" OK)

Then put in C1: =TRIM(A1)&CHAR(10)&TRIM(B1)
and copy C1 down

If you have in A1: Text1, in B1: Text2,
in C1 will appear:

Text1
Text2

Adapt to suit ..
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"stelee" wrote in message
...
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.