How to bold Amount in Text formula

Hi Jalil1985 

I agree that it seems not possible without a macro, but with VBA it is possible.

Put the different parts in separate cells and generate A2 as static text;

Sub boldSum()
    part1 = Range("Part_1").Value
    part2 = Range("Part_2").Value
    part3 = Range("Part_3").Value
    
    Range("a2").Select
    ActiveCell.Value = part1 & part2 & part3
    
    ActiveCell.Characters(Start:=Len(part1), Length:=Len(part2)).Font.FontStyle = "Bold"
End Sub

Thus, the attached file is xlsM.

-/-

i5:i7 are named Part_1 to 3 to be easy possible to move to another sheet with preferences. Cut and paste and tha macro will still be functional.