Preserve Formating

[david.fielding]

Thanks in advance is there any way to preserve formating when
concantenating strings for example


example one


"example" would be aerial font and "one" would be times new roman font,

italic bold for instance


If it is not possible with a formula what about a macro


Cheers
David

 

[Tom Ogilvy]

You would have to reset the formatting, character by character using the
characters method.

You can get a start by formatting some of the characters of a single cell
entry with the macro recorder turned on.

then you can adapt that to loop through the characters and apply the
settings from the originals.