Adding text from 2 cells to a new cell

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
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
 
What happened when you tried it?

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

If you're in R1C1 Reference style mode.
 
Back
Top