Combining text from multiple columns into 1
 

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.

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.

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.

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.