2010 Excel Workbook Contain Email Address

[emphatic]

Hello ,

I am using =IF(ISNUMBER(FIND("@",a1)),a1,"") to get all the email address from column a starting at row 1, then i click and drag down from any column to get anything that contains @. I have 100+ worksheets that I have to do this for , is there a way to apply this to the whole entire workbook ? thank you

[Richard Buttrey]

Difficult to comment without seeing the workbook.

Are there email addresses in many columns or just column A? Are the email addresses embedded in other text in the same cell?

Upload the workbook and maybe we can assist further. If 100 worksheets (and do you mean 100 sheets in a single workbook or 100 workbooks?) are involved then it's likely you'll need a macro.

[emphatic]

thank you the time for responding, I actually figured it out , a simpler way. I just consolidated the sheets together , then just did my formula all the way down .