Excel If statement
Posted on 2011-02-21
Using IF NOT in excel 2010
I have a column of domain names that I would like to separate by extension.
If I use =IF(ISNUMBER(SEARCH(".co",A4)),A4) it will return the domain name Only if it contains .co and not .org.uk or.net however it also returns .co.uk and .com as they both contain .co as well!
How can I separate to JUST the .co or just the .org without the inclusions using some type of =if but NOT statement?