If you have other editions of MS Excel, you can use the Text to Column wizard to split text in Excel. Let us now see how to use the new TEXTSPLIT() function in Excel for the web. Example 1: Using ...

Learn how to use the Text to Columns options to split comma seperated text in Microsoft Excel. You can do the same in Google Sheets as well.