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



"Truc Lopez" <(E-Mail Removed)> wrote in message
news:AF7073FE-FBF5-416D-B9BF-(E-Mail Removed)...
> 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" <(E-Mail Removed)> wrote in message
>> news:6BE2E9AC-C57A-4891-B3A0-(E-Mail Removed)...
>> >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 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" <(E-Mail Removed)> wrote in message
> > news:6BE2E9AC-C57A-4891-B3A0-(E-Mail Removed)...
> > >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