Combine Cells without Concenate or &

J

Johnny B

Hey guys, quick question. How do you combine two horizontal cells without
using Concenate or "&"..?

Example:

| John | Doe |

into

| John Doe |

Thanks!,

Johnny B
 
G

Gary''s Student

Select the first of the pairs and run:

Sub johnnyb()
For Each r In Selection
r.Value = r.Value & " " & r.Offset(0, 1).Value
r.Offset(0, 1).Clear
Next
End Sub

This put the concatenation in VBA rather than in your worksheet.
 
Top