# How to Separate First and Last Names in Google Sheets

Viewport: 1920x951 @0.75x

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

1. [Intro] How to Separate First and Last Names in Google Sheets
   - body: This guide provides a detailed walkthrough for separating first and last names in Google Sheets. Follow these step-by-step instructions to efficiently split names into distinct columns.
   - voiceover: This guide provides a detailed walkthrough on how to separate full names into first and last names in Google Sheets using the 'Split text to columns' feature.
   - audio: https://cdn.layerpath.com/cm5zam9200008kv0cjrs8mqyj/cm6gpke380027ju0cne1nj8fy/cm6gpp7un00000cjo0tjyfjqd.mp3
   - voice: 21m00Tcm4TlvDq8ikWAM
1. step_01 [image] - Select the cells containing the full names
   - source type: IMAGE
   - description: Select the Cells
   - target: (153.3324603184373, 756.9396629843185), rect: top=167.33334350585938 left=47 width=2501 height=1051
   - hotspots: 1
     - hotspot_01 (153.3324603184373, 756.9396629843185), rect: top=167.33334350585938 left=47 width=2501 height=1051
   - dimensions: 1920x951 @0.75x
   - layout: 1 (full)
   - voiceover: Select the cells containing the full names that you want to separate. You can click and drag to select multiple cells or use Ctrl/Cmd + click for individual selections.
   - audio: https://cdn.layerpath.com/cm5zam9200008kv0cjrs8mqyj/cm6gpke380027ju0cne1nj8fy/cm6gppcoe00020cjofrsi15xu.mp3
   - voice: 21m00Tcm4TlvDq8ikWAM
   - image: https://cdn.layerpath.com/cm5zam9200008kv0cjrs8mqyj/cm6gpke380027ju0cne1nj8fy/cm6gpkhpr0000033p4tm9qoiq.png
2. step_02 [image] - Click on the 'Data' tab 
   - source type: IMAGE
   - description: Open the Data Tab
   - target: (357.15053072276555, 19.091606756496574), rect: top=34 left=299.75 width=47.5 height=24
   - hotspots: 1
     - hotspot_01 (357.15053072276555, 19.091606756496574), rect: top=34 left=299.75 width=47.5 height=24
   - dimensions: 1920x951 @0.75x
   - layout: 1 (full)
   - voiceover: Click on the 'Data' tab located in the top menu bar of Google Sheets. This will open a dropdown menu with various data-related options.
   - audio: https://cdn.layerpath.com/cm5zam9200008kv0cjrs8mqyj/cm6gpke380027ju0cne1nj8fy/cm6gppcp800030cjo2zargb45.mp3
   - voice: 21m00Tcm4TlvDq8ikWAM
   - image: https://cdn.layerpath.com/cm5zam9200008kv0cjrs8mqyj/cm6gpke380027ju0cne1nj8fy/cm6gpkm7y0002033pu8sqwpw0.png
3. step_03 [image] - In the dropdown menu, find and click on 'Split text to columns'
   - source type: IMAGE
   - description: Split Text to Columns
   - target: (494.1793554304899, 531.9396645761223), rect: top=540.6666870117188 left=339.0833435058594 width=137.7291717529297 height=17.33333396911621
   - hotspots: 1
     - hotspot_01 (494.1793554304899, 531.9396645761223), rect: top=540.6666870117188 left=339.0833435058594 width=137.7291717529297 height=17.33333396911621
   - dimensions: 1920x951 @0.75x
   - layout: 1 (full)
   - voiceover: In the dropdown menu, find and click on 'Split text to columns'. This option allows you to split the content of the selected cells based on a specified separator.
   - audio: https://cdn.layerpath.com/cm5zam9200008kv0cjrs8mqyj/cm6gpke380027ju0cne1nj8fy/cm6gppcre00040cjo4r7k76hi.mp3
   - voice: 21m00Tcm4TlvDq8ikWAM
   - image: https://cdn.layerpath.com/cm5zam9200008kv0cjrs8mqyj/cm6gpke380027ju0cne1nj8fy/cm6gpko3g0003033p624w9e84.png
4. step_04 [image] - Click on the dropdown menu in this box and select 'Space' 
   - source type: IMAGE
   - description: Choose Separator: Space
   - target: (324.36255884524695, 961.9698916145899), rect: top=970.3333740234375 left=250.89584350585938 width=131.9375 height=20
   - hotspots: 1
     - hotspot_01 (324.36255884524695, 961.9698916145899), rect: top=970.3333740234375 left=250.89584350585938 width=131.9375 height=20
   - dimensions: 1920x951 @0.75x
   - layout: 1 (full)
   - voiceover: A small box will appear under the menu bar. Click on the dropdown menu in this box and select 'Space' as the separator. This will divide the first and last names into separate columns based on spaces between them.
   - audio: https://cdn.layerpath.com/cm5zam9200008kv0cjrs8mqyj/cm6gpke380027ju0cne1nj8fy/cm6gppcsh00050cjoe98zap3r.mp3
   - voice: 21m00Tcm4TlvDq8ikWAM
   - image: https://cdn.layerpath.com/cm5zam9200008kv0cjrs8mqyj/cm6gpke380027ju0cne1nj8fy/cm6gpkree0004033pxv9kjsgu.png
5. step_05 [image] - Ensure that the names have been correctly split into first and last names. 
   - source type: IMAGE
   - description: Review the Split
   - target: (259.02881460062855, 776.1217774994607), rect: top=167.33334350585938 left=47 width=2501 height=1051
   - hotspots: 1
     - hotspot_01 (259.02881460062855, 776.1217774994607), rect: top=167.33334350585938 left=47 width=2501 height=1051
   - dimensions: 1920x951 @0.75x
   - layout: 1 (full)
   - voiceover: Check the resulting columns to ensure that the names have been correctly split into first and last names. Adjust any cells manually if necessary.
   - audio: https://cdn.layerpath.com/cm5zam9200008kv0cjrs8mqyj/cm6gpke380027ju0cne1nj8fy/cm6gppctc00060cjogj2ueams.mp3
   - voice: 21m00Tcm4TlvDq8ikWAM
   - image: https://cdn.layerpath.com/cm5zam9200008kv0cjrs8mqyj/cm6gpke380027ju0cne1nj8fy/cm6gpkxrn0005033p88983yam.png
7. [Outro] Next Steps
   - body: Now that you have separated the first and last names, you can proceed with organizing or processing your data further as needed.
   - voiceover: You've successfully split the full names into first and last names. You can now proceed to format, analyze, or utilize the separated data according to your needs.
   - audio: https://cdn.layerpath.com/cm5zam9200008kv0cjrs8mqyj/cm6gpke380027ju0cne1nj8fy/cm6gpp9ik00010cjohiws7vf7.mp3
   - voice: 21m00Tcm4TlvDq8ikWAM

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