XL.FindEmail function: find and extract an email address from a text string.

XL.FindEmail function – Text function type – returns a first email address found in a text string.

Before you begin, add Functions to Excel

Functions are one of the 20+ features within XLTools Add-in for Excel. Works in Excel 2024, 2019, 2016, 2013, 2010, and Microsoft 365.

– free trial gives you 14 days of full access to all features.

=XL.FindEmail(text)

Argument	Description
text [required]	A text string or a range where you want to find the email address

Download this spreadsheet with examples and try the function yourself.

Formula	Description
`=XL.FindEmail(A2)`	Returns the first email address found in cell A2
`=XL.FindEmail("Contact us at support@xltools.net")`	Returns the first email address found in the specified text string

Any questions or suggestions?

How can we help?