# How to Combine First and Last Name 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 Combine First and Last Name in Google Sheets
   - body: This guide provides a step-by-step walkthrough on how to combine a first name and a last name into a full name in Google Sheets. Follow these steps to seamlessly merge two columns containing first and last names into a new column with the full name.
   - voiceover: This guide provides a step-by-step walkthrough on how to combine first and last names in Google Sheets. Follow the instructions to merge names into a single cell across multiple entries.
   - audio: https://cdn.layerpath.com/cm5zam9200008kv0cjrs8mqyj/cm6grrsp7004zkz0cwmhu7op6/cm6grwwrk000p0cjof3o1c96o.mp3
   - voice: 21m00Tcm4TlvDq8ikWAM
1. step_01 [image] - Choose an empty cell to combine
   - source type: IMAGE
   - description: Open Google Sheets
   - target: (274, 776), rect: top=167.33334350585938 left=47 width=2501 height=1051
   - hotspots: 1
     - hotspot_01 (274, 776), rect: top=167.33334350585938 left=47 width=2501 height=1051
   - dimensions: 1920x951 @0.75x
   - layout: 1 (full)
   - voiceover: Select an empty cell where you want the combined names to appear. Ensure this cell is not occupied or has any existing data.
   - audio: https://cdn.layerpath.com/cm5zam9200008kv0cjrs8mqyj/cm6grrsp7004zkz0cwmhu7op6/cm6grx0oo000r0cjo2gttgsgk.mp3
   - voice: 21m00Tcm4TlvDq8ikWAM
   - image: https://cdn.layerpath.com/cm5zam9200008kv0cjrs8mqyj/cm6grrsp7004zkz0cwmhu7op6/cm6grryn50004033p9lmxbaf4.png
2. step_02 [image] - Click on input bar and type =A29&" "&B29. Modify according to you 
   - source type: IMAGE
   - description: Select the Cell for Full Name
   - target: (249.99872103338103, 102.48556827989229), rect: top=115.66667175292969 left=142.1666717529297 width=2417.83349609375 height=26
   - hotspots: 1
     - hotspot_01 (249.99872103338103, 102.48556827989229), rect: top=115.66667175292969 left=142.1666717529297 width=2417.83349609375 height=26
   - dimensions: 1920x951 @0.75x
   - layout: 1 (full)
   - voiceover: Click on the input bar at the top and type =A29&" "&B29, modifying the cell references A29 and B29 to match the cells containing the first and last names you want to combine.
   - audio: https://cdn.layerpath.com/cm5zam9200008kv0cjrs8mqyj/cm6grrsp7004zkz0cwmhu7op6/cm6grx0qq000s0cjoad8a6qzi.mp3
   - voice: 21m00Tcm4TlvDq8ikWAM
   - image: https://cdn.layerpath.com/cm5zam9200008kv0cjrs8mqyj/cm6grrsp7004zkz0cwmhu7op6/cm6grs0ge0005033p69u1auq1.png
3. step_03 [video] - Click here
   - source type: VIDEO
   - target: (292, 770), rect: top=167.33334350585938 left=47 width=2501 height=1051
   - hotspots: 1
     - hotspot_01 (292, 770), rect: top=167.33334350585938 left=47 width=2501 height=1051
   - dimensions: 1920x951 @0.75x
   - layout: 1 (full)
   - clip: start=5.992 end=20.17 duration=14.178
   - video: url=https://cdn.layerpath.com/cm5zam9200008kv0cjrs8mqyj/cm6grrsp7004zkz0cwmhu7op6/cm6grrsqf004z0ckz2rvv8i1u.webm speed=2 muted=true
   - image: https://cdn.layerpath.com/cm5zam9200008kv0cjrs8mqyj/cm6grrsp7004zkz0cwmhu7op6/cm6grrsqf004z0ckz2rvv8i1u.webm
4. step_04 [image] - Drag the cell down to do the same for other cells
   - source type: IMAGE
   - description: Use the Formula
   - target: (353.0288474693495, 753.9398417156011), rect: top=167.33334350585938 left=47 width=2501 height=1051
   - hotspots: 1
     - hotspot_01 (353.0288474693495, 753.9398417156011), rect: top=167.33334350585938 left=47 width=2501 height=1051
   - dimensions: 1920x951 @0.75x
   - layout: 1 (full)
   - voiceover: Click and hold the small square at the bottom-right corner of the cell with the combined name, then drag it down to apply the same formula to other cells in the column.
   - audio: https://cdn.layerpath.com/cm5zam9200008kv0cjrs8mqyj/cm6grrsp7004zkz0cwmhu7op6/cm6grx0s4000t0cjo75yzga5b.mp3
   - voice: 21m00Tcm4TlvDq8ikWAM
   - image: https://cdn.layerpath.com/cm5zam9200008kv0cjrs8mqyj/cm6grrsp7004zkz0cwmhu7op6/cm6grsbrc0007033plh1rak08.png
5. step_05 [image] - Copy the combined names wherever you want
   - source type: IMAGE
   - description: Press Enter
   - target: (361.0890339322598, 808.0914863806987), rect: top=167.33334350585938 left=47 width=2501 height=1051
   - hotspots: 1
     - hotspot_01 (361.0890339322598, 808.0914863806987), rect: top=167.33334350585938 left=47 width=2501 height=1051
   - dimensions: 1920x951 @0.75x
   - layout: 1 (full)
   - voiceover: You can now paste these combined names wherever needed in your Google Sheets document.
   - audio: https://cdn.layerpath.com/cm5zam9200008kv0cjrs8mqyj/cm6grrsp7004zkz0cwmhu7op6/cm6gryxrl000v0cl877xm5tym.mp3
   - voice: 21m00Tcm4TlvDq8ikWAM
   - image: https://cdn.layerpath.com/cm5zam9200008kv0cjrs8mqyj/cm6grrsp7004zkz0cwmhu7op6/cm6grsevr0008033pr1xhe82k.png
7. [Outro] Review and Adjust
   - body: After pressing Enter, review the new column to ensure the names are combined correctly. If needed, make adjustments or copy the formula to other cells to apply it across rows.
   - voiceover: You have successfully combined first and last names. You can now utilize these combined names for sorting, filtering, or any other operations in your Google Sheets project.
   - audio: https://cdn.layerpath.com/cm5zam9200008kv0cjrs8mqyj/cm6grrsp7004zkz0cwmhu7op6/cm6grwypg000q0cjoc8vl9w0z.mp3
   - voice: 21m00Tcm4TlvDq8ikWAM

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