Return to site

Extract url to domain

broken image

Here, text represents the text string to parse, and delimiter represents the place at which to begin extracting. However, most of the inputs are optional and for this problem, we only need to provide the first two arguments: =TEXTAFTER(text,delimiter) The generic syntax for TEXTAFTER supports quite a number of options: =TEXTAFTER(text,delimiter, ) The TEXTAFTER function returns the text that occurs after a given delimiter. In older versions of Excel, you can use a formula based on the RIGHT, LEN, and FIND functions.

broken image

In the current version of Excel, the easiest way to do this is with the TEXTAFTER function or the TEXTSPLIT function.

broken image
broken image

In this example, the goal is to extract just the domain name from a list of email addresses.

broken image