Formatting concatenated text

T

tapeery

It's easy to concatenate two text strings: =concatenate("Sales: ", "u
last year") would produce "Sales: up last year".

But I want to underline the word "Sales" in the final text string
just not any of the other words or characters.

Can this be done?

Thanks. Tro
 
F

Frank Kabel

Hi
this is not possible with formulas. Formulas can only return values but
not change formats
 
C

cincode5

Troy,

I don't know if this is feasiblein your case but if you were to place the words, "Sales:" & " up last year." in two adjoining cells (with right and left justifications respectively) you could use Conditional Formatting to underline the word "Sales:" The condition would read:

Cell Value is,
equal to, ="Sales:"

....with the format set to Underline = single.

Any cell value other the "Sales:" would not be underlined in this instance. You could even Bold or change colors to draw attention to this fact.

For what its worth...
 
C

cincode5

Just re-read your post and realized that "up last year" was the trigger to underline the word, "Sales". Change the Conditional Formatting of the cell containing the word "Sales:" to read:

Formula Is

=D14="up last year"
(Where D14 is the cell containing the words, "up last year" or whatever else it might contain) and set the format as previously detailed.
 
Top