Thread: Joining text
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Frank Kabel Frank Kabel is offline
external usenet poster
 
Posts: 3,885
Default 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