Excel Inner Text Formatting

[ssimon]

Hello, fine folk.
I have what seems like a complicated formatting problem I could really use some help with.

In column "A" I have text formatted in a specific way. In column "B" is some other text. In column "C" I have a concatenation of columns "A" and "B". Super basic so far. The issue is that I need to be able to make changes to the formatting of text in column "A", and have that formatting reflected in the concatenated result in column "C".

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Some Text[/TD]
[TD]Other Stuff[/TD]
[TD]Some Text Other Stuff[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

Any help is sincerely appreciated. Thank you!

 

[Special-K99]

VBA will do it, though am no expert on this.