Combine 2 cells and only bold data from first cell

[Tashaz]

Hi
I need a VBA script to combine data/text from 2 cells and in the combined cell to only BOLD content from first cell. eg.

Cell B1 = This is Bold,
Cell C1 = this is not bold
Cell A1 = B1 & C1
= This is Bold, this is not bold

See attached.

Thanks.

[jolivanes]

This is going from left to right instead of right to left.
Make sure that the empty cells to the right of the 2nd string are indeed empty.

Please Login or Register  to view this content.

[Tashaz]

Thanks for the quick reply jolivanes that is what I was looking for.

[jolivanes]

Thank you for letting us know.
Good luck