CODEWITHSUNDEEP
google-sheetsjoinsplitgoogle-sheets-formulazero-width-space
Osm
Osm

Reputation: 2881

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

Upvotes: 0

Views: 143

Answers (1)

player0
player0

Reputation: 1

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)

Upvotes: 5

Related Questions