A Function To Extract Email Addresses Posted
I was looking through some old Excel files, and found one from 2002. Apparently, six years ago I had a need to extract emails addresses from text strings. I don't remember it at all. Maybe I was contemplating a new career as a spammer?
In case someone else needs to do this, I posted the VBA function code as a tip: Extracting An Email Address From Text.
I'm sure it's not perfect, but it's probably reliable enough for most uses. The main limitation is that it returns only the first email address in the text. I considered modifying it so it returns all of the email addresses. But then it gets a lot more complicated because the function would need to return an array. So I scrapped that idea.
Spreadsheet Page Blog
Welcome to the Spreadsheet Page Blog. This is where you find the latest news on my books, add-ins, and other Excel-related topics. Comments are welcome.