SOLVED

different formatting in a cell

Copper Contributor

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

1 Reply
best response confirmed by Brade2020 (Copper Contributor)
Solution

@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 best response

Accepted Solutions
best response confirmed by Brade2020 (Copper Contributor)
Solution

@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/

View solution in original post