When you are working with Google Sheets, have you ever needed to split the data contained in one cell, such as student names, into multiple cells? Then here's an easy tip you can use the split text into column options.
Click on the Data tab, and scroll down to "Split text with columns". Then choose how to identify how to split the data from:
- detect automatically
- or custom