SOLVED

different formatting in a cell

%3CLINGO-SUB%20id%3D%22lingo-sub-1460837%22%20slang%3D%22en-US%22%3Edifferent%20formatting%20in%20a%20cell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1460837%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%20I'm%20looking%20for%20a%20solution%20to%20different%20formatting%20in%20a%20cell.%20For%20example%3A%20%3D%22Nr.%20of%20Appels%3A%20%22%26amp%3B%20C12%3CBR%20%2F%3EThe%20result%20should%20look%20like%3A%20%3CSTRONG%3ENr.%20of%20Appels%3A%3C%2FSTRONG%3E%20%3CEM%3E%3CU%3E45pcs%3C%2FU%3E%3C%2FEM%3E%3C%2FP%3E%3CP%3EInstead%20of%3A%20%3CSTRONG%3ENr.%20of%20Apples%3A%2045%3C%2FSTRONG%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1460837%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1460934%22%20slang%3D%22en-US%22%3ERe%3A%20different%20formatting%20in%20a%20cell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1460934%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F698508%22%20target%3D%22_blank%22%3E%40Brade2020%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ENope%2C%20Excel%20doesn't%20provide%20rich%20text%20formatting%20with%20formulas.%20Some%20workarounds%20are%20here%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fwww.mrexcel.com%2Fboard%2Fthreads%2Fformatting-text-bold-within-a-formula.75061%2F%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.mrexcel.com%2Fboard%2Fthreads%2Fformatting-text-bold-within-a-formula.75061%2F%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Visitor

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
Highlighted
Best Response confirmed by Brade2020 (Visitor)
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/