Adding text from 2 cells to a new cell



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

Please help! Thank you.

Peo Sjoblom

What did not work? It is not very helpful to people who are trying to help
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



Peo Sjoblom

Dave Peterson

What happened when you tried it?

Maybe you need:

If you're in R1C1 Reference style mode.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question