how to bold part of a concatenate formula

[evadiva9]

i have a concateate formula in excel. is there any why to bold a portion for the wording?

this is my formula:

=CONCATENATE("Total US Division: ",$A$2," production (",TEXT(Month!D15,"#,###"),") is ",IF(Month!D15<Month!F15,"lower than ","higher than "),$A$2," Outlook (",TEXT(Month!F15,"#,###")," MMcf/d) by ",TEXT(ABS(IMSUB(Month!D15,Month!F15)),"#,###")," ",IF(C7>0,C7,"."))

results:

Total US Division: March gas production () is lower than March Outlook () by 29. it there any way to make the Total US Division bold? so it would appear like this: Total US Division: March gas production () is lower than March Outlook () by 29. thanks in advance for the help!

<tbody>
</tbody><colgroup><col></colgroup>

 

[VoG]

Sorry, no. A formula can only return a value, it cannot format cells.

 

[evadiva9]

do you know if it could be done using a macro? if so do you know the code for the macro?

 

[VoG]

do you know if it could be done using a macro? if so do you know the code for the macro?

Try like this

Sub test()
With Range("A1") 'change to suit
    .Value = .Value
    .Characters(1, 18).Font.Bold = True
End With
End Sub

 

[evadiva9]

that works, but it blows away my formula.
is there any way to for it to work with out pasting values to my formula?

 

[Jonmo1]

that works, but it blows away my formula.
is there any way to for it to work with out pasting values to my formula?

Sorry, but no.
You cannot format "Part" of the result of a formula.
Any formats applied to a cell with a formula will apply to the entire result of that formula.