I have a column with email addresses and other text entries. I want to count the number of email addresses in the column. I tried =COUNTIF(range,"@") to count the number of cells that contain an @ symbol. But that formula did not work, I guess because @ is not by itself in the cell. How do I get it to count@ in the middle of the cell, when there are varying lengths of text?
Bookmarks