Is there a way to format partially using
CONCATENATE in Google Sheets?
=CONCATENATE("*", Sheet1!A1, Sheet1!B1), and I want to make the
* bolded or blue in color or something else.
I realize that I could either:
- Split it across multiple cells and control the color (this does not work for the sheet I am working on because of all else that is going on in the sheet. To begin with, I have merged two cells in order to fit the text. Unmerging would cause the text to be obstructed. Changing the column width would mess with other entries in the same column.)
- Manually convert it to plain text and make the necessary formatting changes. But that too manual.