Joining text
 

I have the following info:

A1-Hello
A2-this
A3-is
A4-a
A5-test

if I wanted to have B1= "Hello this is a test" how do I connect them?

Thank

--
sungen9
-----------------------------------------------------------------------
sungen99's Profile: http://www.excelforum.com/member.php...nfo&userid=914
View this thread: http://www.excelforum.com/showthread.php?threadid=27369

Joining text
 

Hi
=A1 & " " & A2 & " " & A3 & " " & A4 & " " & A5

--
Regards
Frank Kabel
Frankfurt, Germany


sungen99 wrote:
I have the following info:

A1-Hello
A2-this
A3-is
A4-a
A5-test

if I wanted to have B1= "Hello this is a test" how do I connect
them?

Thanks

Joining text
 

In this example, in vba you would go either

Range("B1").Value = Range("A1").Value & " " & Range("A2").Value & ... and
so on.

The other way is directly in the formula bar
=A1&" "&A2&" "&A3&" "&A4&" "&A5

"sungen99" wrote:


I have the following info:

A1-Hello
A2-this
A3-is
A4-a
A5-test

if I wanted to have B1= "Hello this is a test" how do I connect them?

Thanks


--
sungen99
------------------------------------------------------------------------
sungen99's Profile: http://www.excelforum.com/member.php...fo&userid=9144
View this thread: http://www.excelforum.com/showthread...hreadid=273692