Grabbing the domain from a URL

I have a column called ‘Website’.

An example cell would be ‘

I would like to create another column called email that looks like this:

What formula would I use to create this?


I have called the URL variable website (you must replace this with your column name)

What it does…

  • split the URL up into its separate parts where there are dots
  • use slice(-2) to remove all the parts except the last 2
  • join those together again with a dot
  • use Format() to add the ‘@’ character to the front



This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.