Hi guys!

I am trying to join multiple text strings together while still retaining their style settings (eg bold, italic etc). See the example below:

Cell A1: THE FIRST PART OF THE TEXT
Cell B1: The next part of the text

The basic formula is =CONCATENATE(A1," - ",B1) to derive the following:

THE FIRST PART OF THE TEXT - The next part of the text

What I actually want is:

THE FIRST PART OF THE TEXT - The next part of the text

Can anyone advise on this? Alternatively, I could format the text within the CONCATENATE function if I had the right "option" to make text bold in the result.

Any help is welcome. Tx