Solved How To Bold Text In An Excel Formula

March 15, 2020 at 03:14:26
Specs: Windows 10
I would like to bold the outcome of the Last Vlookup applied in the below formula ,

="We have received a request from ",'Final Output'!C3&" ( "&'Final Output'!B3&" ) for a Tax IT project that needs your approval . If you have any questions about this Business Case you can contact <Requestor Name>(Requestor) or"&" "&VLOOKUP('Final Output'!A3,'Pipeline Data'!A:ET,148,FALSE)&"( TBT ) "&" (Both Copied) "


See More: How To Bold Text In An Excel Formula


#1
March 15, 2020 at 09:23:33
The only way to bold a portion of the result from a formula is to use VBA. It can't be done within the formula. In your case, the VBA would need to find the string that you want bolded and something would need to trigger the VBA to start the search.

It might be easier to eliminate the formula and do the entire operation with VBA. Again, something would need to trigger the VBA.

However, your formula looks like it's a communication that is being sent to people. Are you transferring the result to an email or something like that? If so, transferring the text and retaining the bold section may be even more of a challenge.

We need more details about the entire operation before we could offer help.

How To Post Data or Code ---> Click Here Before Posting Data or VBA Code


Report •

#2
March 15, 2020 at 13:03:11
✔ Best Answer
BTW...your formula produces an error. I think you have a comma where there should be an &.

You have: ="We have received a request from ",'Final Output'!C3...

I believe that should be: ="We have received a request from "&'Final Output'!C3...

In addition, at the end of the formula you have:

&"( TBT ) "&" (Both Copied) "

Couldn't that be written as:

&"( TBT ) (Both Copied) "

It looks like you're concatenating 2 text strings.

Let me know if I missed something.

How To Post Data or Code ---> Click Here Before Posting Data or VBA Code


Report •
Related Solutions


Ask Question