I have a very long worksheet list with contact information of various companies and I need to create usernames for them, so I would use the middle part of their website URL for those. For example, in cell
B1 I have
www.yourdomain.com and I want to copy the
yourdomain part to cell
Many websites may have a different top-level domain than .com, but all of them start with 'www.', in the case of 'www.yourdomain.something.com' I would only need the 'yourdomain' part, so from the first dot till the next dot.
Is there a function to accomplish this?