Adding text from 2 cells to a new cell

[Guest]

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.

 

[Peo Sjoblom]

What did not work? It is not very helpful to people who are trying to help
you.
Bob's formula works so column C must be formatted as text or your
calculation must be set to manual or you didn't implement it correctly


--


Regards,


Peo Sjoblom

 

[Dave Peterson]

What happened when you tried it?

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

If you're in R1C1 Reference style mode.