Why the Feature Split Text to Columns or Rows is Required in a Spreadsheet? I’m not going into those details because our topic is different. Since there is no SPLIT function in Excel (at the time of writing this post), there are of course workarounds to achieve the result using a combination of text functions.
You can find that under the Data menu in Google Sheets.Īs I’ve already mentioned above, SPLIT is a function in Google Sheets so it has an edge over Excel’s Text to Column Wizard. Update: Lately Google Sheets has added a menu command for Split called ‘Split text to columns’. If you are familiar with the Excel Convert Text to Column Wizard, it’s equal to that. We are going to learn the use of the Split function Google Sheets in detail here.
With the help of the SPLIT function, you can split text to columns or rows in Google Sheets.
0 kommentar(er)
