Combine data within cells with complex text within destination Cell

[Ganks1978]

I am trying to combine 2 Cells also with text being inserted so the a script can be created. I have 161 lines that this needs to be run on.

(Not the full script)
Example - NewRule - Go Live -BodyContainsWords “COLUMN A” and “COLUMN B” or “COLUMN A” and “COLUMN B”

This will be creating an outlook script but the only variables that I am trying to complete here is to get Column A and Column B information inserted in to the destination cell.

The wording will be constant it is just the text in bold that will need a "formula" to grab the data.

Hopefully this makes sense and I look forward to seeing the suggestions.

Thanks

 

[NdNoviceHlp]

Hi Ganks1978 and Welcome to the Board! A formula solution for A1 combined with B1...

=A1&""&B1

Seems like U actually want a VBA solution. U need to specify where (rows and columns) the data is, a full description of what U want done with it, and exactly what the output should look like. HTH, Dave

 

[Ganks1978]

NdNoviceHlp Thanks or this, it has given me a few more things to consider.

I have moved forward with the problem and this assisted me.

 

[NdNoviceHlp]

You are Welcome. Thanks for posting your outcome, Dave