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

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

But not showing this error.

CodePudding user response：

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:

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)