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

Example:

| John | Doe |

into

| John Doe |

Thanks!,

Johnny B

As far as I am aware, you can't.

"Johnny B" wrote:

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

Example:

| John | Doe |

into

| John Doe |

Thanks!,

Johnny B

.... unless you use VBA (sorry!)

"Johnny B" wrote:

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

Example:

| John | Doe |

into

| John Doe |

Thanks!,

Johnny B

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.
--
Gary''s Student
gsnu200712