Does Excel support mixed formatting of a string in a formula cell,yet?

[Bland]

Excel is one of the most spectacular apps ever created. But one
feature I really need is mixed formatting of a string whose cell is a
formula.

By mixed formatting I mean, you know, making selected (as opposed to
all) character(s) of the string bold, italic, a different color, sub-
or superscripted, etc. In Excel 2002 you cannot do that in a formula
cell (right?).

In edit mode, the user would, say, press F9 to display the calc'ed
string, selectively format it as usual, then cancel edit. Excel would
save the formatting as a separate mask. What could be easier?

The user would be responsible for reformatting the string if the
formula result changes (but only when the string shifts right or left
relative to his formatting.) That responsibility would be a cheap
price to pay for this feature.

Stated another way, cell formatting in Excel is only half implemented.
If you are going to implement a feature, then implement it.

Does the latest version of Excel do this? If not, can someone get MS's
ear about it?

Thanks.

 

[Bob Umlas]

Excel 2007 does NOT allow this in formulas.
Bob Umlas
Excel MVP

 

[Bland]

Bob:

Thanks very much for rapid reply.

Is there any place on microsoft.com where I can request or suggest
this feature?

Thanks.

 

[Bob Umlas]

They already know of this request. I'm attending the MVP Summit next week
and I can suggest it again!

 

[Bland]

Bob:

That is *tremendous*!

If they don't agree, filibuster.

Thanks again.

 

[Shailesh Shah]

Workaround is to use vba code.

BTW this features are found in alternate Integrated Software called
Framework from www.framework.com.

Shailesh