# how to split cells in google sheets

Viewport: 1910x922 @1.125x

Playback: autoplay=false durationMs=3000 navBar=false arrows=true callouts=true browserBar=false browserTheme=light

1. [Intro] How to Split Cells in Google Sheets
   - body: 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.
   - voiceover: Learn how to split the contents of a cell into multiple columns in Google Sheets using the 'Split text to columns' feature. This step-by-step guide will help you navigate through the process efficiently.
   - audio: https://cdn.layerpath.com/cm6jao3nc0004ju0cgnmqyz10/cm8otcd8e000ci80c5z7kaijs/cm8otib8h000j0cjl1u44e4e7.mp3
   - voice: 21m00Tcm4TlvDq8ikWAM
1. step_01 [image] - Navigate to your Google Sheets document where you wish to split cells. You can do this by opening your browser, going to Google Sheets, and selecting your document.
   - source type: IMAGE
   - description: Open the Google Sheets
   - target: (521, 545), rect: top=165.7777862548828 left=46 width=1640 height=604
   - hotspots: 1
     - hotspot_01 (521, 545), rect: top=165.7777862548828 left=46 width=1640 height=604
   - dimensions: 1910x922 @1.125x
   - layout: 1 (full)
   - voiceover: Navigate to your Google Sheets document where you wish to split cells. You can do this by opening your browser, going to Google Sheets, and selecting your document.
   - audio: https://cdn.layerpath.com/cm6jao3nc0004ju0cgnmqyz10/cm8otcd8e000ci80c5z7kaijs/cm8otigfz000l0cjl584g6kpc.mp3
   - voice: 21m00Tcm4TlvDq8ikWAM
   - image: https://cdn.layerpath.com/cm6jao3nc0004ju0cgnmqyz10/cm8otcd8e000ci80c5z7kaijs/cm8otcikz000103huvvoqhcus.png
2. step_02 [image] - Click on the cell that contains the data you want to split. Make sure the cell is highlighted.
   - source type: IMAGE
   - description: Select the Cell
   - target: (302, 148), rect: top=141.7777862548828 left=46 width=1640 height=24
   - hotspots: 1
     - hotspot_01 (302, 148), rect: top=141.7777862548828 left=46 width=1640 height=24
   - dimensions: 1910x922 @1.125x
   - layout: 1 (full)
   - voiceover: Click on the cell that contains the data you want to split. Make sure the cell is highlighted.
   - audio: https://cdn.layerpath.com/cm6jao3nc0004ju0cgnmqyz10/cm8otcd8e000ci80c5z7kaijs/cm8otiggk000m0cjl6pnl2wuy.mp3
   - voice: 21m00Tcm4TlvDq8ikWAM
   - image: https://cdn.layerpath.com/cm6jao3nc0004ju0cgnmqyz10/cm8otcd8e000ci80c5z7kaijs/cm8otckbe000203hum1589aud.png
3. step_03 [image] - Go to "Data". A dropdown menu will appear with various options.
   - source type: IMAGE
   - description: Open the Data Menu
   - target: (312.9999779914806, 74.21792148894173), rect: top=34 left=295.3194580078125 width=46.59722137451172 height=23.55555534362793
   - hotspots: 1
     - hotspot_01 (312.9999779914806, 74.21792148894173), rect: top=34 left=295.3194580078125 width=46.59722137451172 height=23.55555534362793
   - dimensions: 1910x922 @1.125x
   - layout: 1 (full)
   - voiceover: Go to the 'Data' menu. A dropdown menu will appear with various options.
   - audio: https://cdn.layerpath.com/cm6jao3nc0004ju0cgnmqyz10/cm8otcd8e000ci80c5z7kaijs/cm8otigh4000n0cjl7z2o0mmd.mp3
   - voice: 21m00Tcm4TlvDq8ikWAM
   - image: https://cdn.layerpath.com/cm6jao3nc0004ju0cgnmqyz10/cm8otcd8e000ci80c5z7kaijs/cm8otcmm1000303huochvt2xe.png
4. step_04 [image] - From the dropdown menu, select the option 'Split text to columns'. This will open a small interface at the bottom of the selected cell.
   - source type: IMAGE
   - description: Choose Split Text to Columns
   - target: (511, 573), rect: top=569.5555419921875 left=334.2083435058594 width=267 height=20
   - hotspots: 1
     - hotspot_01 (511, 573), rect: top=569.5555419921875 left=334.2083435058594 width=267 height=20
   - dimensions: 1910x922 @1.125x
   - layout: 1 (full)
   - voiceover: From the dropdown menu, select the option 'Split text to columns'. This will open a small interface at the bottom of the selected cell.
   - audio: https://cdn.layerpath.com/cm6jao3nc0004ju0cgnmqyz10/cm8otcd8e000ci80c5z7kaijs/cm8otighs000o0cjl51rwfm3l.mp3
   - voice: 21m00Tcm4TlvDq8ikWAM
   - image: https://cdn.layerpath.com/cm6jao3nc0004ju0cgnmqyz10/cm8otcd8e000ci80c5z7kaijs/cm8otco5o000403huahgstmtm.png
5. step_05 [image] - Choose Separator – Select a delimiter (comma, space, etc.).


   - source type: IMAGE
   - description: Select the Separator
   - target: (566.9753358856269, 643.9999770962336), rect: top=641.888916015625 left=451.6111145019531 width=131.93055725097656 height=20
   - hotspots: 1
     - hotspot_01 (566.9753358856269, 643.9999770962336), rect: top=641.888916015625 left=451.6111145019531 width=131.93055725097656 height=20
   - dimensions: 1910x922 @1.125x
   - layout: 1 (full)
   - voiceover: Choose a delimiter (comma, space, etc.) from the available options. This will determine how your cell contents are split.
   - audio: https://cdn.layerpath.com/cm6jao3nc0004ju0cgnmqyz10/cm8otcd8e000ci80c5z7kaijs/cm8otigih000p0cjl2ygm68vo.mp3
   - voice: 21m00Tcm4TlvDq8ikWAM
   - image: https://cdn.layerpath.com/cm6jao3nc0004ju0cgnmqyz10/cm8otcd8e000ci80c5z7kaijs/cm8otcu4b000503hu7goiymnc.png
6. step_06 [image] - Once the separator is selected, Google Sheets will automatically split the content of the cell into multiple columns based on the chosen delimiter.
   - source type: IMAGE
   - description: Verify the Split
   - target: (411, 665), rect: top=165.7777862548828 left=46 width=1640 height=604
   - hotspots: 1
     - hotspot_01 (411, 665), rect: top=165.7777862548828 left=46 width=1640 height=604
   - dimensions: 1910x922 @1.125x
   - layout: 1 (full)
   - voiceover: Once the separator is selected, Google Sheets will automatically split the content of the cell into multiple columns based on the chosen delimiter.
   - audio: https://cdn.layerpath.com/cm6jao3nc0004ju0cgnmqyz10/cm8otcd8e000ci80c5z7kaijs/cm8otigj0000q0cjl8yqf3njv.mp3
   - voice: 21m00Tcm4TlvDq8ikWAM
   - image: https://cdn.layerpath.com/cm6jao3nc0004ju0cgnmqyz10/cm8otcd8e000ci80c5z7kaijs/cm8otczbp000703hu4429gjdn.png
8. [Outro] Next Steps
   - body: You have successfully split the cells in your Google Sheets document. You can now proceed to format the new columns, analyze the data, or perform further operations. If you need to split more cells, repeat the steps above.
   - voiceover: You have successfully split the cell contents into multiple columns. You can now format, analyze, or manipulate the data as required. If you need further assistance, consider exploring other features of Google Sheets or referring to additional help documentation.
   - audio: https://cdn.layerpath.com/cm6jao3nc0004ju0cgnmqyz10/cm8otcd8e000ci80c5z7kaijs/cm8otie9t000k0cjlf2yc46er.mp3
   - voice: 21m00Tcm4TlvDq8ikWAM

Source: https://share.layerpath.com/share/cm8otcd8e000ci80c5z7kaijs/tour