How to split text in a cell into multiple cells in Google Sheets

Are you ready to rock and roll with split cells in Google Sheets? Well, you’re in luck because today I feel like a quick Google Sheets guide so I’m going to show you step-by-step how to split cells like a pro!

Let’s go!

First things first: make sure you open up Google sheets and have your data ready. Because splitting cells is no joke, you want to make sure you have everything in order.

Now let’s get started.

1: Highlight the cells you want to split.

Excel cell

2: Select the “Split Text to Columns” option, located under the “Data” tab.

Google sheets data menu

3: Select the delimiter option, which is the character that separates the data.

Google sheets split cell delimiter selection
Select delimiter

4: Once you’ve chosen your delimiter( I usually just use “Detect automatically), click “OK” – and bam! Cells split!

Note: The process is similar in Microsoft Excel, the option there is called, “Text to columns”, just click on it once you have selected the cell with the data you want to put into multiple cells.

You did it! You just split cells like a champ. Now that wasn’t so bad, was it?

I hope these steps have made splitting cells in Google Sheets a little bit easier. But don’t forget, practice makes perfect, actually that is not true, practice does not make perfect it makes progress, perfection is never achieved.

Related Posts

phone as alarm

How to change alarm sounds on iPhone

To change the sound of the alarm on your iPhone you can do it in a few steps, open the Clock app and tap the Alarm tab, Tap Edit, Tap the alarm, make your changes, then tap Save.

Cookies on a phone

How to clear cookies on iPhone

To clear you cookies on the iPhone, go to Settings -> Safari -> Advanced > Website Data, then tap Remove All Website Data.

An apple in a TV

How to delete app on Apple tv

Deleting an app on the AppleTV is thankfully very easy, select the app you want, tab the touch sensitive area, press the play/pause button and then select “Delete”. And that is it.

A tablet

How to change iPad name

Changing the name of your iPad is a simple process that can be completed in just a few steps. Here’s how to do it:
Go to “settings” > “General” > “About” > change the name there.

a projector

How to link a Google slide to another slide

Linking slides can be a great way to create a seamless presentation, Here I will show you how to do it in 5 easy steps. Select Image or text to put the link on, CTRL K or Command k, Link and select the slide you want to link to.


How to search for a word on Google docs

In windows press “CTRL + f” and It will pop up a little search windows on the top right

Leave a Reply

Your email address will not be published. Required fields are marked *