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.
|