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 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
