google-sheetsjoinsplitgoogle-sheets-formulazero-width-space

Why does split works without a delimiter?

I encountered this formula here, Why the split works without a delimiter?

=SPLIT(A2&"​"&B2, "​")

enter image description here

But not showing this error.

enter image description here

Solution

  • meet the evil U200B character - also called zero width space

    https://unicode-table.com/en/200B/

    it lives in zero-dimensional space but still counts as a valid character:

    enter image description here

    mainly used to confuse developers and coders. or in cryptography to encrypt hidden messages and sometimes even used as a workaround to disable the dash - in the "text splitting on the end of the row" (for example Photoshop)