cell features to appear in formula

[RIZVI]

hello friends,

attached is a SAMPLE document where you will see that A7 represents a formula representing cells A1:A4.
A1:A4 cells have different features such as some are bold, underlined, different in size etc.
how can i get cell A7 to appear having same features of cells A1:A4?
could we have a general VBA so that first it checks for bold, underlined text as per contents in the formula and thereafter it shows the exact contents as appearing in the selected cells.

thank you

regards
rizvi