I have a spreadsheet with a column of cells that each cell contains multiple emails. I want to create a formula that will give me a total of all emails in each cell.
Cell A1 Contains ("[email protected],[email protected],[email protected]")
I'd like help in figuring out how to count the number of emails in A1 which would be "3". Can this be done by counting the @ sign?
I have a very large spreadsheet with thousands of emails that I need to total.
I have tried CountA, Count, Search but can't figure this out.
Thanks in advance for any help
You could try:
=LEN(A2) - LEN(SUBSTITUTE(A2, "@", ""))
This compares the length of the original cell to the length with all @ synbols removed, to infer the number of @ symbols.
Collected from the Internet
Please contact [email protected] to delete if infringement.
Comments