Grabbing the domain from a URL

1

I have a column called ‘Website’.

An example cell would be ‘www.amazon.com’

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

@amazon.com

What formula would I use to create this?

2

image

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

Max

3 Likes