---
title: "How To Split Cells In Google Sheets"
h1: "How To Split Cells In Google Sheets"
description: "Learn how to split cells in Google Sheets effortlessly. Our step-by-step guide provides tips and tricks to enhance your spreadsheet skills today."
route: "/learn/how-to-split-cells-in-google-sheets"
canonical: "https://www.layerpath.com/learn/how-to-split-cells-in-google-sheets"
---

# How To Split Cells In Google Sheets

This guide will walk you through the steps to split cells in Google Sheets. Splitting cells allows you to divide the content of a cell into multiple cells based on a delimiter such as a comma, space, or any other character.

### Interactive Layerpath tour

Canonical tour: https://share.layerpath.com/e/cm8otcd8e000ci80c5z7kaijs/tour

Tour id: cm8otcd8e000ci80c5z7kaijs

1. Open **Google Sheets** and select the cell containing the data you want to split.
2. Click on **Data** in the top menu and select **Split text to columns** from the dropdown.
3. Google Sheets will automatically detect a separator, or you can select one (comma, space, semicolon, etc.).
4. The data will be split into multiple columns based on the chosen separator.
5. If you need more control, use the **TEXTSPLIT** function with a custom delimiter.