Bold Font question

[Guest]

Good Afternoon All,

I currently have a formula that pulls data results from one page and places
them in another along with additional text. I've seen several posts that
note bolding one word is not possible and I'm just wondering if that is in
fact correct. I've been able to change single words to Caps if needed (see
Exp. 1), but I'm able to just write Bold and get the same results (Exp. 2).

Thank you for your review as always and appreciate any thoughts or advice -
Jenny B.

Exp. 1 (Works)
="This questionnaire asks you to evaluate the job performance of" &" " &
Upper('Test Results Data'!G49) & " " &Upper('Test Results Data'!F49) &"." &"
" & "The information you are providing is for research purposes only, and
will not become part of the employee's official record."

Exp.2 (Does not Work)
="This questionnaire asks you to evaluate the job performance of" &" " &
Bold('Test Results Data'!G49) & " " &Bold('Test Results Data'!F49) &"." &" "
& "The information you are providing is for research purposes only, and will
not become part of the employee's official record."

 

[Guest]

Alas - there isn't a way to make only a portion of a formula bold

UPPER() works because that is an Excel function.

There is no similar function to change the font or font attribute of a string.

 

[Dave Peterson]

Just to make clear...

This won't work with a formula--if Jenny converts the formulas to values, then a
technique like this will work.

 

[Guest]

Thank you everyone for all of your helpful suggestions.

Though you are correct that a macro might do the job, I was just looking for
a simple fix and at least now I have my answer.

Thank you once again - Jenny B.