0

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

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

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

  • Yes, this is what I'm after unfortunately. – user650654 Jun 25 at 5:00

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.