Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Create a formula by joining text and the value from a formula | Excel Worksheet Functions | |||
Joining dates and text in formula | Excel Worksheet Functions | |||
Joining text in one cell | Excel Worksheet Functions | |||
JOINING OF TEXT & DATE | New Users to Excel | |||
Joining text in multiple cells | Excel Programming |