Forum Discussion
Formating a part of the cell text in result of a function?
=concatenate("Sample text ",$A$1," another text") I want the text in reference i.e. A1 resultantly display as bold font. I tried my best to solve this problem but not successful. Any suggestions ple...
Don't think it be done. Formulas can't be formatted other than adding new-lines. You can try setting a custom format, but the minute your $A$1 cell value changes the format needs to be changed too. You can do it programmatically using VBA to collate the text, then write that to the cell and by code set the format.
Alternatively you have 3 cells for the result, where $A$1 is in the middle cell and that cell is formatted as bold/
Alternatively you have 3 cells for the result, where $A$1 is in the middle cell and that cell is formatted as bold/