I am trying to automate the process of changing the font size within a single cell, in this case the cell is D2 which contains the formula:
=A2&" "&B2&"."&C2
the visual result in D2 looks like this £1.99
the value in A2 is £
the value in B2 is 1
and the value in C2 is 99
however I need the £ sign to be 8 point text, the 1 needs to be 12 point, and the 99 needs to be 8 point.
Can this be done automatically through a formula or through a macro?[/b]
=A2&" "&B2&"."&C2
the visual result in D2 looks like this £1.99
the value in A2 is £
the value in B2 is 1
and the value in C2 is 99
however I need the £ sign to be 8 point text, the 1 needs to be 12 point, and the 99 needs to be 8 point.
Can this be done automatically through a formula or through a macro?[/b]