Converting Text to different cells in the File or in the column

Copper Contributor

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 use to?

 

The Text could be separate by comas, What to do in this case to achieve the goal?

 

1 Reply
B1:
=transpose(filterxml(webservice("http://e.anyoupin.cn/eh3/?preg_match_all~(\S)~" & A1),"document/items[1]/items"))

suppose A1=Kant Hegel Marx