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

How to use FindEmail function for Excel: formula and results
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 2019, 2016, 2013, 2010, desktop Office 365.

Get started with XLTools ribbon
– free trial gives you 14 days of full access to all features.

Syntax

=XL.FindEmail(text)
ArgumentDescription
text
[required]
A text string or a range where you want to find the email address

Examples [download]

Download this spreadsheet with examples and try the function yourself.


FormulaDescription
=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?