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
together.

Please help! Thank you.

Adding text from 2 cells to a new cell
 

=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.

Adding text from 2 cells to a new cell
 

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.

Adding text from 2 cells to a new cell
 

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



"Truc Lopez" wrote in message
...
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.

Adding text from 2 cells to a new cell
 

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