Organizing list of websites and subdomains

[snmt]

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!

[humacdeep]

Hi Snmt,

Welcome to the forum!!

If you just want count of the domains & sub domains that has site.com you can try the below formula assuming your list is in Column A.

Please Login or Register  to view this content.

If this is not your requirement, please upload the sample file.

Regards,
Humac

[mikerickson]

Try this formula
=IF(ISNUMBER(FIND("site.com",A1)),"site.com",A1)

[snmt]

Try this formula
=IF(ISNUMBER(FIND("site.com",A1)),"site.com",A1)

this was perfect, thank you!