code

I hate Excel - Extracting a domain name from a hostname

Assuming that cell B2 has a hostname like foo.bar.baz.example.com the following will extract just the domain name form the hostname, e.g. "example.com" =CONCATENATE(RIGHT(LEFT(B2,LEN(B2)-4),LEN(LEFT(B2,LEN(B2) »