Joining text

  • Thread starter Thread starter sungen99
  • Start date Start date
S

sungen99

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
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA Linest function for polynomial regression on horizontal range 0
Moveing Rows 4
Loop by Group Within Group 6
How to delete ALL cells containing the same data 1
Removing Sequential Numbers 4
Need macro that transforms key words into predefined numbers 2
macro which delets cell if the cell above has the same keyword 2
transpose 1

Back
Top