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

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

[aliihsanburak]

It was really useful. Thanks a lot bro. You saved a lot of time for me 🙏

[professionalliability]

my middle name column turns black. It does not woirk. What am I doung wrong. I copied and pasted middle name first