Forum Discussion
Converting Text to different cells in the File or in the column
For example Text: Kant Hegel Marx (convert to Files). Result 3 different files. Or Text Kant Hegel Marx (convert to Columns). Result 3 different columns. How to achieve it? Which fomulas we have to...
B1:
=transpose(filterxml(webservice("http://e.anyoupin.cn/eh3/?preg_match_all~(\S)~" & A1),"document/items[1]/items"))
suppose A1=Kant Hegel Marx
=transpose(filterxml(webservice("http://e.anyoupin.cn/eh3/?preg_match_all~(\S)~" & A1),"document/items[1]/items"))
suppose A1=Kant Hegel Marx