Preserving text format/style - concatenate function

[michaelc]

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

[Carim]

Hi,

I am afraid you will need VBA to format each part separately ...
something like

Please Login or Register  to view this content.

HTH
Carim

[michaelc]

Thanks Carim,

Will give that a go. It's worth it as I have over 8000 lines and can't be bothered to format each one manually!

Ciao

[Carim]

Well before stepping into the loop... just make sure you have properly coded the lenght, which means correctly spotted your separator " - " ...

HTH
Carim