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


https://c.scudata.com/article/1651916536524
https://c.scudata.com/article/1659236901556
https://c.scudata.com/article/1659317654097