Can an Excel Formula Bold Part of Its Result? Solutions & Workarounds
Question details
The user wants to apply bold formatting to specific words or characters returned within the text string of an Excel formula.
- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Combining text using formulas like TEXTJOIN and wanting to highlight or bold only specific words within the returned result.
- Observed behavior
- Formulas only return plain text values. Conditional formatting and standard formulas cannot selectively apply bold styles to only a portion of a cell's text.
Standard spreadsheet formulas only calculate and return values; they cannot apply rich text formatting. To format only a portion of the text, you will need to rely on VBA macros or structural workarounds.
Use a VBA Macro to Apply Partial Formatting
Since formulas cannot bold specific words, converting the formula to a static value and using a VBA macro is the standard method to selectively format characters in a text string.
VBA (Visual Basic for Applications) allows you to automate text styling. Note that the cell must contain a static text string rather than an active formula for partial formatting to be applied.
Go to File > Options > Customize Ribbon and check the Developer option to make it visible on your top menu.
Press Alt + F11 to open the Visual Basic for Applications window, then click Insert > Module from the top menu.
Enter a VBA script that targets the specific cell and uses the Characters(Start, Length).Font.Bold = True method to apply the styling.
Close the VBA editor and press Alt + F8 to select and run your new macro, which will bold the targeted words inside the cell.
Use Multiple Columns as a Visual Workaround
If you prefer not to use macros, you can split your text across adjacent columns and apply native formatting to specific cells to create the illusion of a single sentence.
Switch to WPS Office for a Seamless Spreadsheet Experience
While spreadsheet formulas universally cannot bold partial text, WPS Spreadsheet offers an exceptionally smooth, lightweight alternative to Microsoft Excel. It handles your complex data perfectly and provides identical UI elements so you can migrate effortlessly.
- 1. Download the software: Visit the official WPS website and download the free installer for your operating system.
- 2. Install WPS Office: Follow the on-screen instructions to quickly install the suite on your device.
- 3. Open your spreadsheet: Double-click your existing Excel files to automatically open them in WPS Spreadsheet with zero format loss.
Frequently Asked Questions
Can Conditional Formatting bold specific words in a cell?
No. Conditional formatting applies styles to the entire cell based on the cell's overall value. It cannot target or format specific words within a text string.
Can I use HTML tags in my Excel formula to bold text?
No, standard Excel formulas do not support rendering HTML tags. Including tags like <b> in your formula will simply result in those tags appearing as plain text in the cell.
Does the TEXT function support rich text formatting?
The TEXT function can change how numbers, dates, and currency are displayed by modifying the number format, but it cannot alter font weights, styles, or colors.
