Format only parts of a formula result?

  • Thread starter Thread starter sdubose99
  • Start date Start date
S

sdubose99

I created a formula composed mostly of text, including a small formula.
This formula:

="The products would be $"&ROUND(E28/1000,0)&"K but since new revenues
are enabled almost instantly,"

is intended to produce:

The products would be $1335K but since new revenues are enabled almost
instantly,

Is there a way to BOLD or ITALICIZE the "$1335K" result but leave the
other text unbolded?

Scott
 
Not and keep it a formula.

Formulas don't work with this kind of character by character formatting--and
neither to numbers.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Concantenate which keeps bold of some parts. 5
VLOOKUP returns formula instead of result 1
Column of formulas with some cells containing data derived from thereformula's I would like to find 2
Excel Drag autofill only part of formula 3
Change color of a particular category label in Excel 2007 1
Results of formula vs real numbers 3
How to max out results of a formula. 6
Formula to format selective part in a text 6

Back
Top