Add an invisible, zero-width, transferrable tag to a text value.
Syntax: \UNTAG(tagged_text) => text
=LAMBDA(tag_text,
UNICHAR(917539) & REDUCE("",SEQUENCE(LEN(tag_text)),LAMBDA(acc,val,
LET(
c, UNICODE(RIGHT(LEFT(tag_text,val),1)),
acc & IF(AND(c>31,c<127),
UNICHAR(c+917504),
""
))
)) & UNICHAR(917631)
)
Documentation
Turns input_text into an invisible tag by changing each ASCII character to its zero-width, invisible equivalent from the Unicode Tags block. The tag can be appended to a cell value. Appends the Tag version of # to the beginning and Cancel Tag character (last character in the Unicode Tags block) to the end of the tag.
Tagging affects the length of the cell contents, but not its display.
Tagging cells containing numbers or dates will result in text values, that cannot be directly used in calculations.
Use \UNTAG() to remove tags.
Usage:
=A1 & \TAG(“some tag”)
Outputs the contents of A1 tagged with invisible text “some tag”.
