...
15.8 Take out words
There is a text data table:
To take out the number strings in the text:
=spl("=?1.words@d()",A1)
To take out the English words and the number strings in the text:
=spl("=?1.words@a()",A1)
To take out all the characters: split Chinese characters/symbols into single character, and split English words/numbers into single word:
=spl("=?1.words@w()",A1)
esProc Desktop and Excel Processing
15.7 Take out different types of characters
15.9 Parse and extract Key-Value pair