Extract right after first space in Excel and Google Sheets

=MID(A2,FIND(" ",A2)+1,256)

A2 = data cell; "  " = criteria (space)

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

Extract right after first space in Excel

How to extract a text after space in a string in Excel?
Extract right after first space in Excel

EXTRACT RIGHT AFTER FIRST SPACE  — EXCEL FORMULA AND EXAMPLE

=MID(A2,FIND(" ",A2)+1,256)

This formula will extract any value right after the first space and is most suitable for a text string containing two words. For example, first and last name. You can change the space ("  ") to your criteria in the above formula

Extract right after first space in Google Sheets

How to extract a text after space in a string in Google Sheets?
Extract right after first space in Google Sheets

EXTRACT RIGHT AFTER FIRST SPACE — GOOGLE SHEETS FORMULA AND EXAMPLE

=MID(A2,FIND(" ",A2)+1,256)

This formula will extract any value right after the first space and is most suitable for a text string containing two words. For example, first and last name. You can change the space ("  ") to your criteria in the above formula

Other useful extract formulas in Excel and Google Sheets explainedOthers FormulasDate and time functionsNumber based criteriaText-based criteriaExtract functions