Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formatting Text in a Formula?
(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.? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formatting Text in a Formula?
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... ----------------------------------------------------------------------- "dj479794" wrote in message ... (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.? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula Text String: Formatting Text and Numbers? | Excel Discussion (Misc queries) | |||
Conditional formatting based on text within a formula | Excel Worksheet Functions | |||
Formatting text which is result of formula | Excel Discussion (Misc queries) | |||
How do I copy text formatting using a formula? | Excel Discussion (Misc queries) | |||
Concatenation formula loses text wrap formatting | Excel Discussion (Misc queries) |