I need to compile data from multiple cells from one column into a single cell. Some of the source cells are formatted with as underlined text. I need to retain the formatting after the cells are merged into the destination cell. I found VBA to combine two ranges of cells and retain the source formatting, and it was more than I needed. How can I use just one range of cells and combine them? I don't want spaces or commas between the output values (I'll provide them when needed).

Example:

Source:

A1= "It is going to cost "
A2= "$1000.00" (A2 is formatted to underline value)

Destination: (desired result)

B2= "It is going to cost $1000.00" (A2 value is still underlined)


My plan is to custom build each cell column A so that a macro can string the results together in one cell formatted as a paragraph with source formatting retained. I could use the concatenate function except it loses the source character formatting.

Please help gently...very new to VBA