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 3 years ago on June 19th, 2018. Last modified on September 16th, 2019

Related To:


Recommended
The best free alternative to Grammarly : ProWriteAid
Up to 35% OFF AliDropship Plugin

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:

0/5 (0 Reviews)
Do we all agree that Coffee is the fuel that feeds the free content creating?
Connecting Databases to Google Sheets with KPIBees

One of those tools that help connect and process data from Google Sheets to Databases, is KPIBees. Find out more in this post

UseSQL to connected data across Google Sheets, Airtables & More

UseSQL allows you to easily turn your data into databases by connecting data across multiple apps.The data source can be […]

10 Tips For Improving Productivity Of Remote Teams

Freelancers are used to working from home. They can work from anywhere in the world with a decent Internet connection […]

Boost Your Business Strategy With Vizologi

Vizologi is a unique platform helps you shape your business strategy. bringing creative ideas to life. boost tour business strategy.

Online PDF To Flipbook Converter

Heyzine is the best way to create awesome online publications convert PDF to Flipbooks

Landing Pages Optimization: Writing & Design Tips

Landing page optimization writing and design tips to help you build the best landing page for your business, product, and services.

App Development Agency: Here’s Why You Need A Mobile App

Getting credible services from a legit app development agency is essential. Here’s an article to read why an app can help your business.

Leave a Reply

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

menu-circlecross-circle