Hi, I'm looking for a solution to different formatting in a cell. For example: ="Nr. of Appels: "& C12The result should look like: Nr. of Appels: 45pcsInstead of: Nr. of Apples: 45

Brade2020 Nope, Excel doesn't provide rich text formatting with formulas. Some workarounds are here https://www.mrexcel.com/board/threads/formatting-text-bold-within-a-formula.75061/

Forum Discussion

Brade2020

Copper Contributor

Jun 13, 2020

Solved

different formatting in a cell

Hi, I'm looking for a solution to different formatting in a cell. For example: ="Nr. of Appels: "& C12
The result should look like: Nr. of Appels: 45pcs

Instead of: Nr. of Apples: 45

excel

SergeiBaklan
Jun 13, 2020
Brade2020

Nope, Excel doesn't provide rich text formatting with formulas. Some workarounds are here https://www.mrexcel.com/board/threads/formatting-text-bold-within-a-formula.75061/

1 Reply

SergeiBaklan
Diamond Contributor
Jun 13, 2020
Brade2020

Nope, Excel doesn't provide rich text formatting with formulas. Some workarounds are here https://www.mrexcel.com/board/threads/formatting-text-bold-within-a-formula.75061/