Splitting full name into first and last name on google sheet 

OMG you're amazing. Thank you for sharing.

What about multiple names?

Thank you for this brother/sister 🙏

What if first name or last name has two words in it?

Thank you!!

thank you , this helpful

How about if I want to convert "Last Name, First Name, Middle Initial" into "First Name Middle Initial Last Name"? Thank you

So good sir.

=split(B2, " ")

What if first name or last name has two words in it?