I've seen this done before with just formulas, but I can't find how to do it anymore.The idea is to have the following:
a1="The amount owed is "
a2="$25.38"
a3=". Contact Jeff."Cell a4= a1&a2&a3 (which displays as "The amount owed is $25.38. Contact Jeff.")
As far as I know, you can't bold only a portion of a Text string that is the result of a formula. I know of 3 ways to accomplish your goal: 1 - Carefully size and position multiple cells to make it look like one and then Bold the cell that contains the portion that you want bolded.
2 - Use VBA (a macro) to convert the result of the formula into a value and bold the desired characters via the same code. Let me know if that method interests you.
3 - Carefully size and position a text box that is linked to a cell which contains the portion that you want bolded as described here:
https://wmfexcel.wordpress.com/2014...
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.
Ad Choices