Improved Splitting of Text into Sheets Columns

A while back I wrote this post about splitting data into multiple columns in Google Sheets.

A small update has made this task a little easier. When you paste data into a sheet, a small contextual menu now appears. Clicking on this offers the option to Split text into columns:

Click image to enlarge

Click image to enlarge

Clicking on this option carries out the split, but offers you an option to choose a different delimiter if you wish:

Click image to enlarge

Click image to enlarge

Alternatively, you can select the columns you want to split, then click Data > Split text to columns. A menu will appear beneath the data, allowing you to perform the split using commas, semicolons, periods, spaces, or even custom separators.