Format text in concat to bold, italic, etc


I'm excited to have learned but now I cant figure out how to BOLD, Underline, italics certain words in a sentence. Example: I would like L29 or P29 in bold or italic

="This instrument was ACKNOWLEDGED before me by "&L29&" as "&P29&" of"

1 Reply
best response confirmed by BayouCityMasonry (Visitor)


It is not possible in Excel to format part of the result of a formula differently from the rest.

As a workaround, place the parts of the sentence in different cells. Each cell can have its own formatting.