I have a formula that pulls in numbers into a text string but i want to
underline or bold the numbers being pulled in and selected parts of the text.
Is this possible?

eg cell formula
="john is "&A1&" years old" where cell A1 is 10
returns
"john is 10 years old"
ideally i want the 10 to be bold and the old to be underlined

even if the cell the number is being drawn from (A1 in this case) is bold or
underlined the format is not pulled into the result of the formula

many thanks

(nb i have excel 2002)