MicrosoftAbout formatting with concatenate
Only we need to preserve is font formating. No alignment (cell property), no conditional formatting (cell computed property)
We have a way to format different parts of cell (select part of text and chose format) and this is case only for texts (labels)
Only we need is 2 functions
=FTEXT(ref) - resulting cell content WITH formating markup (visible) as format-preserved result
=FCONCATENATE(range) - concatenating formatpreserved range (CONCATENATE(FTEXT(range))
plus very positive to have following functions
=BOLD(true/false) - produsing BOLD markup
=BOLD(cell) - =BOLD(true) & cell & BOLD(false)
... similar for others formattings
=FONT([name],[size],[color],[kind],cell), might be =FONT([name],[size],[color],[kind],true/false)
might be change a bit CELL(ref,"format") functionality - or extend or add keyword "markup"
those few functions might solve all the case
PS! I have in my functions library =HLINK(ref,[n]) what works opposite to =HYPERLINK producing URL from cell containing links
the reason is that several integrations (query, copy/paste) producing NAMED HYPERLINKS into cells
and there is now other way to read out the actual URL from those cells
Extreamly positive to have something like as standard - =HLINK or =URL or whatever
JUst recalling this requirement in conjuction with new =IMAGE function
