Excel 2002.

I need to change fonts and font colour, within the one cell.

For example, begin the cell with a Red Wingding Bullet at 10pt, followed by
an Item Description in Arial Black 10pt, followed by a Sub-Description in
Black in say 8Pt Arial. E.g. - Adjustable Paper Tray (A6 to A3)

When you are typing directly into a cell in Excel, you can do this quite
easily.

However, when the cell needs to be populated with a formula, I cannot find a
way to do this.

What is needed is some sort of coding, like the [Red] code you can use in
Number Formats, but it needs to be an extension of this concept.

For example, in a Concatenate statement to build up a cell from three
separate elements, such as

"-"," Adjustable Paper Tray"," (A4-A3)"

it should be possible to say something like
[Bold][Red][Wingding][10pt]"-",[Regular][Black][Arial]" Adjustable Paper
Tray",[8pt]" (A4-A3)"

to achieve the same font & colour control in a formula as you can when
typing directly into the cell.

Is there any way of doing this in Excel as it is? If not,is there any chance
of incorporating such a function into the next version?