Whether you use = A1 & B1 or = CONCATENATE(A1, B1), it's a formula. The
first uses the concatenate operator, &, and the second uses the concatenate
function, CONCATENATE( A, B ).

Let's see. You're not allowed to use a formula. How about two formulas?

A macro?
--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

"muckali" wrote in message
...
Hey, go to the microsoft helper guy, and enter in "CONCATENATE" that
should
do it for you! It's not a formula it's a function ;)



"April" wrote:

I need to be able to merge two colums of text into one column without
lossing
the information and I'm not allowed to use a formula! This is an
assignment
and we are allowed to use any resource to find our answer. I hope
someone
can give me a hand. Thanks

April