Flip the first and last name in Excel and Google Sheets

=MID(A2&" "&A2,FIND(" ",A2)+1,LEN(A2))

A2 = data cell

Check below for a detailed explanation with pictures and how to use formulas in Excel and Google Sheets.

Flip the first and last name in Excel

How to flip the first and last name in Excel?
Flip the first and last name in Excel

FLIP THE FIRST AND LAST NAME — EXCEL FORMULA AND EXAMPLE

=MID(A2&" "&A2,FIND(" ",A2)+1,LEN(A2))

Flip the first and last name in Google Sheets

How to flip the first and last name in Google Sheets?
Flip the first and last name in Google Sheets

FLIP THE FIRST AND LAST NAME — GOOGLE SHEETS FORMULA AND EXAMPLE

=MID(A2&" "&A2,FIND(" ",A2)+1,LEN(A2))

Other widely used Excel and Google Sheets formulas explainedOthers FormulasDate and time functionsNumber based criteriaText-based criteriaExtract functions