Formula to combine text?
 

Greetings. I need a little help. Is it possible to combine text from to
different cells together with a formula? Example: A1 = My name B1 = is
Will, and I want C1 to say My name is Will. Is this possible? Thanks in
advance for any help.

Yep....

=CONCATENATE(A1,B1)

--
Regards,

Dave


"coal_miner" wrote:

Greetings. I need a little help. Is it possible to combine text from to
different cells together with a formula? Example: A1 = My name B1 = is
Will, and I want C1 to say My name is Will. Is this possible? Thanks in
advance for any help.

Greetings. I need a little help. Is it possible to combine text
from to
different cells together with a formula?
=A1&B1

=A1&" "&B1
=A1&" "&B1&" Smith"
etc. etc. etc.

arno

Thank you, works perfect.

"DaveB" wrote:

Yep....

=CONCATENATE(A1,B1)

--
Regards,

Dave


"coal_miner" wrote:

Greetings. I need a little help. Is it possible to combine text from to
different cells together with a formula? Example: A1 = My name B1 = is
Will, and I want C1 to say My name is Will. Is this possible? Thanks in
advance for any help.

Read up the function CONCATENATE()


coal_miner Wrote:
Greetings. I need a little help. Is it possible to combine text from
to
different cells together with a formula? Example: A1 = My name B1 =
is
Will, and I want C1 to say My name is Will. Is this possible? Thanks
in
advance for any help.


--
Morrigan
------------------------------------------------------------------------
Morrigan's Profile: http://www.excelforum.com/member.php...fo&userid=7094
View this thread: http://www.excelforum.com/showthread...hreadid=396869

Another way to do the same thing is

=A1&B1

But in either case, you need either a trailing space in A1 or a leading
space in B1 to keep it from reading "My nameis Will"

or, you can do it in the formula, as:

=A1&" "&B1

Vaya con Dios,
Chuck, CABGx3


"coal_miner" wrote:

Thank you, works perfect.

"DaveB" wrote:

Yep....

=CONCATENATE(A1,B1)

--
Regards,

Dave


"coal_miner" wrote:

Greetings. I need a little help. Is it possible to combine text from to
different cells together with a formula? Example: A1 = My name B1 = is
Will, and I want C1 to say My name is Will. Is this possible? Thanks in
advance for any help.