Format Different Parts of Text in One Excel Cell
Question details
The user wants to apply different formatting to individual words or characters within one Excel cell.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- The user wants some text in a cell to appear bold, italic, or otherwise styled differently from the rest.
- Observed behavior
- Manually entered text can have mixed formatting, but a formula result cannot normally retain different font styles within its returned text.
Select the cell and check the formula bar. If its contents begin with an equals sign, the displayed text is a formula result and needs a different approach.
Format selected characters in a manually entered cell
Use this method when the cell contains text entered directly rather than a formula.
Double-click the cell, or select it and click inside the formula bar.
Drag over the words or characters you want to format.
On the Home tab, click Bold or Italic, or choose another available font option. Press Enter to finish editing.

Work around mixed formatting in a formula result
Use separate cells to keep the result dynamic, or convert the result to text before formatting individual characters.
Format individual words in a cell with WPS Spreadsheets
Use WPS Spreadsheets to select and format part of a manually entered cell, or paste a formula result as a value before styling it.
- 1. Open the spreadsheet: Open WPS Spreadsheets and use Open to select your workbook.
- 2. Edit the cell: Double-click a cell containing manually entered text.
- 3. Select the characters: Drag over the word or characters you want to change.
- 4. Apply the style: Click Bold or Italic on the Home tab, then press Enter to finish.

Frequently Asked Questions
Can I bold just one word in an Excel cell?
Yes. Double-click a cell containing manually entered text, select the word, and click Bold on the Home tab.
Why can't I format part of a formula result?
Excel formulas return a value rather than rich text with individual character styles. Use separate cells for dynamic components or paste the result as a value before formatting it.
Will a pasted formula result update automatically?
No. Home > Paste > Values creates a static value. Keep the formula in another cell if you still need a result that updates.
Can VBA format individual characters in a cell?
Yes. VBA can use a cell's Characters.Font property to format selected characters in static text. It does not preserve mixed formatting within a live formula result.




