Combine Cells and Add Text

[CircleG]

Hi. I want to combine two cells and add text. Then delete column D.

Example attached.

Thanks for your help!

[Rschwar23]

hi CircleG,
Try this:

Please Login or Register  to view this content.

[Moo the Dog]

For a non-VBA solution, you can put this formula in cell H3 and fill down as far as you want:

="Condition: "&C3&CHAR(10)&"Result: "&D3

Then, copy that data from column H and using 'Paste Special: Values', paste it over the data column C. Then you can delete the data in column D and H.

- Moo

* Note, if using a Mac, the CHAR code should be CHAR(13), instead of CHAR(10).... darn Macs!

[CircleG]

Thanks for the speedy responses. Both the macro and formula work great. Thanks for sharing your knowledge!

[Moo the Dog]

Glad to help, and thanks for the feedback. =)

- Moo