Clean up domain list in Excel - regex / macros?
- by Tim
I have a huge spreadsheet of domains that I need to clean up as follows:
Remove all http:// (simple replace all - "http://" with "")
Remove any www. (simple replace all - "www." with "")
Delete any sub-domains (delete the actual row completely, not just the subdomain from the url)
Remove anything after the domain extension (i.e.…