PIT Designs Logo

How to Split Cells in Google Sheets (2 Steps)

I'm the owner and founder of PIT Designs. I love creating digital presence and creative digital solutions for our clients.


Posted 5 years ago on June 19th, 2018. Last modified on September 16th, 2019

Related To:

Things to Consider Before Designing a Logo

Every company needs its unique identity, so everybody designs a logo, but what should we take care of while designing a logo? Let's find out.

Tips On How To Be Safe When Using The Internet

We all know the importance of staying safe on the internet. With how much time we spend online these days, […]

How a Rephraser can Help you Improve your Social Media Presence

Having a problem with your social media content? Too much competition to deal with? Worry not! Here is how a Rephraser can help.

How Automation Software Help with Payroll Processing

Automation software greatly reduces payroll processing errors, enhances compliance, increases efficiency, and makes paychecks easier to create and file. Automation […]

How To Stay Safe While Surfing The Internet

The Internet is a part of our everyday life nowadays. Every day we spend a good amount of time on […]

Business Books Entrepreneurs Must Read to Dominate Their Industry

Whether you aspire to start a small business or launched a digital marketing agency, you must spend sufficient time reading […]

The Creative Entrepreneur: Exploring Career Opportunities for Innovators and Problem-Solvers

All entrepreneurs need problem-solving and innovative skills. Finding solutions or creating new possibilities is accomplished through problem-solving. The ability to […]

Top 2D Animation Tools in 2023

Shopping for 2D animation software for your next project? Here are five of the best 2D Animation tools that are worth exploring.

Google Sheets, is the cloud-based version of Google's spreadsheet solution. You can think of it as an easy-to-use, less complicated and most importantly, Free alternative to Microsoft Excel. Google Sheets is a powerful tool for data analysis and manipulation, for the daily tasks.

A common request one might have is, how to split cells in Google Sheets? i.e to split data of one cell into multiple cells, based on a certain criteria.

The easiest way to achieve this is by using the free add-on from Ablebits.com called : Power Tools for Google Sheets (get the add-on for Chrome from here)

STEP ONE

Get the add-on and, go to Add-ons > Power Tools > Split

STEP TWO

Select the cells you want to split, and choose the criteria for splitting. The Power Tools provide a number of available criteria, you’ll find blank space, linked break, coma or any other custom character of your choosing and more. Here's an example of two different criteria:

Split Cells by Space, in the example the cell contains two words separated by space (PIT Designs) we need to split the one cell into two cells, one for each word.

Split Cells by special character, in this case we have one cell contains (PIT Designs - Creative Digital Solutions), we need to split this one cell into two cells, one of them contains PIT Designs the other Creative Digital Solutions, the way to do so is by selecting custom criteria character "-" which separates the words, and here's the result: