Different font size, same cell, changing text only, vba

[DPARDY]

Thank you for your time,

In cell A1 is pasted values form concat of cells A2 & A3. Both A2 & A3 text will be changing all the time, what I need to do is only decrease the font size of the text that comes from A3.

Thanks Again.

 

[mikerickson]

The problem is that you need a formula in the cell, to respond to changing data.
But cells that have a formula cannot have fonts of different sizes. The characters in a cell that holds a formula will all be the same size.