| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Combine Cells without Concenate or &
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Combine Cells | Excel Discussion (Misc queries) | |||
| Combine Cells | Excel Discussion (Misc queries) | |||
| Combine Cells | Excel Worksheet Functions | |||
| combine cells | Excel Discussion (Misc queries) | |||
| Combine cells | Excel Worksheet Functions | |||
Hybrid Mode
