How do I use the Excel Formula To Pull Email From a column formula?

Paste the formula into the first output cell, then fill down to apply it to your range.

Can I use this in Google Sheets or WPS?

Yes. Use the Sheets or WPS version shown below. Adjust ranges to match your sheet.

Formula Library

Pull email a column with a ready-to-use formula for Excel, Google Sheets, and WPS.

Pull email a column.

ExcelWPS

=LET(tokens, TEXTSPLIT(A2, " "), FILTER(tokens, ISNUMBER(SEARCH("@", tokens))))

View platform differences

=REGEXEXTRACT(A2, "(?i)[A-Z0-9._%+-]+@[A-Z0-9.-]+\.[A-Z]{2,}")

Extract email a text string with a ready-to-use formula for Excel, Google Sheets, and WPS.

Extract email raw text with a ready-to-use formula for Excel, Google Sheets, and WPS.

Extract email a full row with a ready-to-use formula for Excel, Google Sheets, and WPS.

Extract email address a text string with a ready-to-use formula for Excel, Google Sheets, and WPS.

Extract email address raw text with a ready-to-use formula for Excel, Google Sheets, and WPS.

Extract email address a full row with a ready-to-use formula for Excel, Google Sheets, and WPS.