Ampersand from another sheet and keeping two different text colors VBA

 

Hi Im trying to get a code that can take data from multiple cells from sheet1 and place them in the same cell on sheet2 but the tricky part is keeping the same colors of the text from sheet1.

For example:

sheet one 
A1-Roses
A2-Are Red

should read on sheet2:

A1-Roses Are Red

By: zgivod

Leave a Reply

Your email address will not be published. Required fields are marked *