Formatting Text in a Formula?

[Guest]

(Excel 2003)

[A1]
= " The ACME Corporation robot can do " &TEXT(C3, "#,###")& " things at one
time."

how can I put the words "ACME Corporation" in Bold face text and not the
rest of the sentence.?

 

[Earl Kiosterud]

You can't do character-level formatting with the results of a formula.

You could use something like:

=C3

Then format it (Format - Cells - Number tab - Custom), and in the "Type" box, put:

"The ACME Corporation robot can do" #,### " things at one time"

--
Earl Kiosterud
www.smokeylake.com

Note: Top-posting has been the norm here.
Some folks prefer bottom-posting.
But if you bottom-post to a reply that's
already top-posted, the thread gets messy.
When in Rome...