How to Extract Separate First Name, Middle Name, and Last Name on Google Sheets

How to Extract Separate First Name, Middle Name, and Last Name on Google Sheets

Channel:
Indonesia Tongbos_EN
Subscribers:
123,000
Published on ● Video Link: https://www.youtube.com/watch?v=Lpc0f9yDr_8


Duration: 6:26
4,955 views
30

here the solution to extract names into separate column of first, middle, and last name..

here the formula:

at B2 Cell [First name]:
=trim(if(C2="",REGEXREPLACE(A2,D2&"|,",""),REGEXREPLACE(A2,C2&"|"&D2&"|,","")))

at C2 Cell [Middle name]:
=trim(if(iserror(REGEXEXTRACT(A2," (.*) ")),"",REGEXEXTRACT(A2," (.*) ")))

at D2 Cell [Last Name]:
=trim(substitute(IF(COUNTIF(A2,"*,*")=1,REGEXEXTRACT(A2,"(.*), "),REGEXEXTRACT(A2," .*$")),C2,""))

#googlesheet #extractspearate #firstname #middlename #lastname



Other Videos By Tongbos_EN


2021-07-16Cara melakukan pembayaran melalui transfer bank di Shopee
2021-07-15How to Check Facebook Activity Log and History
2021-07-15How To Delete Discord Channels And Servers
2021-07-14Cara Lihat Riwayat Pesanan Shopeefood
2021-07-14How to Bulk Convert CR3 to JPEG
2021-07-14Cara Membagikan Koin Penjual di Shopee Live
2021-07-13Cara menghapus Audio Reels Instagram
2021-07-13Cara Mengaktifkan Snooze pada Orang, Halaman, atau Grup di Facebook
2021-07-12How To Add Groovy Bot To Discord Server
2021-07-12Cara Hapus Draf Reels Instagram
2021-07-11How to Extract Separate First Name, Middle Name, and Last Name on Google Sheets
2021-07-11Cara Mendapatkan Voucher Diskon Shopeefood
2021-07-09Cara Mengisi Saldo Shopeepay Tanpa Biaya Admin
2021-07-09How To Use The Green Screen Overlay In CapCut
2021-07-08[SOLVED] Can't Move or Drag Icons at Home Screen on Xiaomi Redmi Note 10 Pro
2021-07-08How To Hide Your Activity On Instagram
2021-07-08How To Report An Instagram Account
2021-07-08How To Boost Your TikTok Videos
2021-07-07Cara Mengecek Riwayat Transaksi ShopeePay Saya
2021-07-07How To Sort Your Videos Using TikTok's Playlist Feature
2021-07-07How To Mute Words On Twitter


Tags:
google sheets
first name
middle name
last name
separate names