Microsoft Excel Tutorial – How to extract user name from email ID?

Microsoft Excel Tutorial - user name from email

This post contains formula to extract user name from email ID in Microsoft Excel. Check SayPeople.com for more information.

Formula to extract user name from an email ID Rectangle.826 SayPeople.com SayPeople.com Rectangle.1068 SayPeople.com SayPeople.com Rectangle.796 Formula to extract user name from an email ID Formula to extract user name from an email ID Rectangle.831 =IFERROR(LEFT(A1,SEARCH("@",A1)-1),"") =IFERROR(LEFT(A1,SEARCH("@",A1)-1),"") Dynamic connector.832 Dynamic connector.834 gives gives Dynamic connector.835 example example 2-D word balloon.842 Suppose email address is present in A1 Suppose email address is present in A1 Sheet.70 Sheet.71

You can also get Usman’s book on “Basic Biostatistics with Basic Steps in Microsoft Excel” here: https://amzn.to/40XjM1K (Affiliate link)

Usman Zafar Paracha

Usman Zafar Paracha is a sort of entrepreneur. He is the author of "Color Atlas of Statistics", and the owner of an Android game "Faily Rocket."

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.