How To Deconstruct An Email Address

[mcgonma]

I am looking for a way to deconstruct or disect email addresses in Excel. Here is the situation.

I have about 300 email addresses in and Excel spreadsheet in the following format:
namename@agency.state.md.us where the word "agency" is the actual name of the person's agency within the organization
I need to create a way to extract "agency" name from this email address.

Do you know of a formula, or approach (i.e., series of formulas in columns), or even a tool that I can use to do this?

 

[Richard Schollar]

Hi

Perhaps a formula to extract:

=TRIM(LEFT(SUBSTITUTE(REPLACE(A1,1,FIND("@",A1),""),".",REPT(" ",100)),100))

 

[Datsmart]

Here is a formula that seems to do the job:

Excel Workbook
	A	B
1	namename@agency.state.md.us	agency
Sheet

 

[mcgonma]

Thank you SO much for your replies!!!
The "=TRIM" function formula works perfectly.
One thing I didn't anticipate that becomes a problem in the formula for the "=MID" function formula is that the second FIND(".",A9) portion of the formula returns an error if the first part of the email address has a "." in it (i.e., name.name@agency.state.md.us)
Again...thank you all SO much for expanding my knowledge of all the things that Excel can do that I had absolutely no idea about. Truly amazing!!!