Forum Discussion

HelgaSte's avatar
HelgaSte
Copper Contributor
May 30, 2023

Changing font colour when concatenating text

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

 

  • Zala-No1's avatar
    Zala-No1
    Copper Contributor

    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 

    • HelgaSte's avatar
      HelgaSte
      Copper Contributor

      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! 

Resources