Changing font colour when concatenating text

Copper Contributor

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".



3 Replies


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

@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 

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