H1 in column with formula

[Paul_Danyliuk]

You can use a formatted template to fill with text and preserve paragraph formatting data:

Format() with style

Following the discovery of big buttons, I was tempted to see if something similar was possible with Format() — namely if one could supply a Big Cell formatted content as a template for the Format() function. Answer: YES! although a bit limited. [image] What is preserved when the text is pasted into the {1} {2} etc templates: Paragraph formatting: headers, lists, code blocks, text alignment etc What is NOT preserved: Span formatting: text color and highlight, bold/italic/etc. It gets ove…