0

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

player0
  • 124,011
  • 12
  • 67
  • 124
Osm
  • 2,699
  • 2
  • 4
  • 26

1 Answers1

6

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)

player0
  • 124,011
  • 12
  • 67
  • 124
  • I Konw it [at first sight](https://stackoverflow.com/questions/73962198/count-the-number-of-occurrences-of-a-string-combination-with-2-columns/73966191?noredirect=1#comment130601249_73966191), i said something is hidden But, you kept silent. ಠ_ಠ – Osm Oct 05 '22 at 23:01
  • @Osm but, but it is not hidden, it's there, can't you see it? \*smug-smirking emoji\* – player0 Oct 05 '22 at 23:08