The Google Suite is great for its ease of use, but sometimes it's missing features that you are used to from the desktop programs that you are used to. One of these things is taking text that is in one column and splitting it into many. The classic example of this is when you have first and last names in one column and you want to split it into two. Take note that anything in the columns to the right could get written over if the text goes into those columns.
To split text what you need to do is: highlight the column with the the text to split, click on the Data menu and then split text to columns. You will now be prompted to choose the separator. This is the trigger that Google Sheets will use to know when to split the text. Choose the one that applies to your data and your data will be split. How easy is that?!
If you are more of a visual person, take a look at the video below.