Formatting Text in a Formula?

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.?
 
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...
 
Back
Top