Joining Text from two Cells into One
 

If I have input "Jhon Doe" into cell A1 and "Jane Doe" into cell A2, how
can I get cell B1 to read

"Jhon Doe & Jane Doe"

If it were numbers I would write the following in B1, =A1+A2, but even
that would just add the two numbers together. And since it's text I'm
clueless. Any ideas?


--
Juan
------------------------------------------------------------------------
Juan's Profile: http://www.excelforum.com/member.php...fo&userid=6889
View this thread: http://www.excelforum.com/showthread...hreadid=574453

Joining Text from two Cells into One
 

=a1&" & "&a

--
davesexce

-----------------------------------------------------------------------
davesexcel's Profile: http://www.excelforum.com/member.php...fo&userid=3170
View this thread: http://www.excelforum.com/showthread.php?threadid=57445

Joining Text from two Cells into One
 

You already gave the answer yourself.

=A1 & B1 will give "Jhon DoeJaneDoe"
=A1 & " & " & B1 will give "Jhon Doe & Jane Doe"



"Juan" schreef in
bericht ...

If I have input "Jhon Doe" into cell A1 and "Jane Doe" into cell A2, how
can I get cell B1 to read

"Jhon Doe & Jane Doe"

If it were numbers I would write the following in B1, =A1+A2, but even
that would just add the two numbers together. And since it's text I'm
clueless. Any ideas?


--
Juan
------------------------------------------------------------------------
Juan's Profile:
http://www.excelforum.com/member.php...fo&userid=6889
View this thread: http://www.excelforum.com/showthread...hreadid=574453

Joining Text from two Cells into One
 

Thanks alot Dave, that did the trick!!!!!

--
Jua
-----------------------------------------------------------------------
Juan's Profile: http://www.excelforum.com/member.php...nfo&userid=688
View this thread: http://www.excelforum.com/showthread.php?threadid=57445