Solved How to make a portion of concatenated text bold? is[b]Y[/b]1

Microsoft Excel 2010 - complete product...
December 15, 2014 at 08:45:52
Specs: Windows 7, i5

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.")


See More: How to make a portion of concatenated text bold? is[b]Y[/b]1

Report •


#1
December 15, 2014 at 15:06:23
✔ Best Answer
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.


Report •
Related Solutions


Ask Question