公式库

Excel Formula To Capture Email Address From A Text String

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

快速答案

Capture email address a text string.

统一公式

ExcelWPS
=LET(tokens, TEXTSPLIT(A2, " "), FILTER(tokens, ISNUMBER(SEARCH("@", tokens))))
查看平台差异

Google Sheets

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

使用说明

需要定制版本？

相关公式

Excel Formula To Extract Email From A Text String

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

Excel Formula To Extract Email From Raw Text

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

Excel Formula To Extract Email From A Full Row

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

Excel Formula To Extract Email Address From A Text String

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

Excel Formula To Extract Email Address From Raw Text

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

Excel Formula To Extract Email Address From A Full Row

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