15.8 Take out words

 

There is a text data table:

imagepng

To take out the number strings in the text:

=spl("=?1.words@d()",A1)

imagepng

To take out the English words and the number strings in the text:

=spl("=?1.words@a()",A1)

imagepng

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)

imagepng


esProc Desktop and Excel Processing
15.7 Take out different types of characters
15.9 Parse and extract Key-Value pair