Yes...there is always data in A...but there may or may not be data in B & C
I'm trying to get the concatenate formula to work but so far no go...here's
what I have now
=CONCATENATE(I8," ",J8," ",K8)
not sure tho if this is to be put into an adjoining empty column or in the
column that will be the finished data above in column I or in my
exempla...column A ?


"RagDyer" wrote in message
...
Is there a possibility there might be data in Column C and *no* data in
ColumnB?


--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Tim" wrote in message
...
In Excel 2003...I have three long columns A , B , & C. Some of the
individual cells contain text...some don't. Is there a way to combine
these columns into column A without losing the text that now exist in
column A ?
Here's what I have:
Col A Col B ColC
Bob & Mary
Bill
etc

When done I would like:

Col A Col B ColC
Bob & Mary
Bill

Thanks, Tim R