Google-sheets – Partial cell formatting with CONCATENATE in Google Sheets

concatenateformattingformulasgoogle sheetsgoogle-sheets-cell-format

Is there a way to format partially using CONCATENATE in Google Sheets?

For example, =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:

  1. 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.)
  2. Manually convert it to plain text and make the necessary formatting changes. But that too manual.

Best Answer

If you are after this then it's not possible:

0

You can do this only manually.

If you just want more visible star you can use one of these instead like:

=CONCATENATE("✱", Sheet1!A1, Sheet1!B1)

0

✱ ★ ☆ ✢ ✥ ✦ ✧ ❂ ❉ ✯ ✰ ✲ ✴ ✵ ✶ ✷ ✸ ❇ ✩ ✪ ✫ ✬ 
✭ ✹ ✺ ✻ ✼ ❈ ✮ ✡ ✾ ✿ ❀ ❁ ❃ ❊ ❋ ✣ ✤ ✽ ⁂ ⁑ ✳ 
❄ ❆ ❅ ⋆ ≛ ☪

Related Topic