Changing font colour when concatenating text

[HelgaSte]

Is there a way of changing the font colour or style when concatenating text in a excel spreadsheet?

So say adding an operation to the following: 

That would give "test and measure" rather than just a straight CONCAT result of "test and measure".

Thanks

[#2]

@HelgaSte 

No, it is not possible to format part of the result of a formula differently from the rest.

[#3]

@HelgaSte   Yes, it is definetely possible using vba code 

easy way to do is record macro of concat to see its formate now just give attribute to that part which u want chatgpt might be helpful 

[#4]

@Zala-No1Thanks for the suggestion, that is a good technique to know. Unfortunately the operation I was trying to do could not be recorded. I will continue to play with it an see!