This forum seems like a complete gift from the internet. Thank you in advance.
I have a long list of subdomains in one column of Excel that need to be consolidated if they are from the same main site.
eg. site.com, forum.site.com, & home.site.com all need to be counted together.
Is there a formula that would tell excel "if cell contains 'site.com' replace the text in that cell with 'site.com'"? (I don't need to keep the data of what the subdomains were, as I just need the data in their rows grouped next to each other.)
Thanks!
Bookmarks