Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
stelee
 
Posts: n/a
Default 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.
  #2   Report Post  
Max
 
Posts: n/a
Default

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.



  #3   Report Post  
stelee
 
Posts: n/a
Default

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.




  #4   Report Post  
Max
 
Posts: n/a
Default

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.



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Text to Columns from drop down list update Kurgan Excel Discussion (Misc queries) 0 June 21st 05 12:14 PM
Connect multiple columns in 1 row to another? tb New Users to Excel 1 March 4th 05 10:57 PM
Text to columns will not shut off. Gerald Cornforth Excel Worksheet Functions 5 December 15th 04 02:39 AM
Why text to columns is not available when there is mulipule line . Bing Excel Worksheet Functions 1 December 8th 04 06:14 AM
splitting text to multiple columns maryj Excel Discussion (Misc queries) 5 December 1st 04 04:37 PM


All times are GMT +1. The time now is 10:44 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"