What happened when you tried it?

Maybe you need:
=rc[-2]&rc[-1]

If you're in R1C1 Reference style mode.

Truc Lopez wrote:

Bob,

Thank you for your reply, however, it did not work. Any other ideas?
"Bob Phillips" wrote:

=A1&B1

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Truc Lopez" wrote in message
...
I have two columns containing text. I would like to add the text from the
2
columns to a new column.

Example: a1 = abc and b1 = def and I would like to have c1 reads abcdef
all
together.

Please help! Thank you.




--

Dave Peterson