{"id":12105,"date":"2011-12-16T16:42:59","date_gmt":"2011-12-16T16:42:59","guid":{"rendered":"http:\/\/www.learnexcelmacro.com\/?p=1014"},"modified":"2017-07-01T10:18:55","modified_gmt":"2017-07-01T10:18:55","slug":"extract-email-id-from-a-string","status":"publish","type":"post","link":"https:\/\/vmlogger.com\/excel\/2011\/12\/extract-email-id-from-a-string\/","title":{"rendered":"How to Extract Email ID from a String in Cell"},"content":{"rendered":"
If you want to extract email ID from a String Stored in any cell, it is possible by writing a Simple UDF (User Defined Function) in Excel. After writing this UDF, you can use this function as a normal Excel Function.<\/p>\n
Follow the below Steps: 1. <\/strong>The below formula extract only one email ID which appears first in whole String
\n1.<\/strong> Open Visual Basic Editor (Alt+ F11)
\n2.<\/strong> Open an Existing Module or add a New Module
\n3.<\/strong> Copy Paste the below Code and Save the Excel.
\n4.<\/strong> Now Go to any Cell of any Sheet of your Workbook and use this formula =GetEmailID(Cell)<\/strong><\/p>\nLimitations:<\/h3>\n
\n 2. <\/strong>If many @ and . Signs are there then it may return wrong Value
\n
\n