Google Sheets Formula for Extracting Domain From Website?

by

try:

=ARRAYFORMULA(INDEX(SPLIT(REGEXREPLACE(A8:A12, "https?://www.|https?://|www.", ), "/"),,1))

0

enter image description here

UPDATE 1:

=ARRAYFORMULA(IFNA(REGEXEXTRACT(INDEX(SPLIT(
 REGEXREPLACE(A8:A14, "https?://www.|https?://|www.", ), "/"),,1), 
 "\.(.+\..+)"), INDEX(SPLIT(
 REGEXREPLACE(A8:A14, "https?://www.|https?://|www.", ), "/"),,1)))

0

UPDATE 2:

=INDEX(IFERROR(REGEXEXTRACT(A1:A, "^(?:https?:\/\/)?(?:ftp:\/\/)?(?:www\.)?([^\/]+)")))

enter image description here

More Related Contents:

  1. How would I import YouTube Likes and Dislikes and a ratio from YouTube onto Google Sheets? [closed]
  2. What is the best regular expression to check if a string is a valid URL?
  3. Getting parts of a URL (Regex)
  4. Regular expression to find URLs within a string
  5. How to get domain name from URL
  6. What is the best regular expression to check if a string is a valid URL?
  7. ArrayFormula of Average on Infinite Truly Dynamic Range in Google Sheets
  8. Regex to check if valid URL that ends in .jpg, .png, or .gif
  9. Is there a custom function or script that returns gid of a specific sheet in Google Sheets?
  10. Multiple regex matches in Google Sheets formula
  11. Selecting the last value of a column
  12. Can a URL contain a semicolon and still be valid?
  13. Extracting top-level and second-level domain from a URL using regex
  14. ArrayFormula and “AND” Formula in Google Sheets
  15. Difference between two dates expressed as years, months, days (in one column)
  16. ARRAY_LITERAL, an Array Literal was missing values for one or more rows
  17. How to use arrayformula with formulas that do not seem to support arrayformulas?
  18. In ARRAY_LITERAL, an Array Literal was missing values for one or more rows – indirect formula error in google spreadsheet
  19. How to create INDIRECT array string of multiple sheet references in Google Sheets?
  20. How to extract domain name from url?
  21. Match linebreaks – \n or \r\n?
  22. Notepad++ incrementally replace
  23. Regex that does not allow consecutive dots
  24. How can I insert a tab character with sed on OS X?
  25. Lazy quantifier {,}? not working as I would expect
  26. How do I use a new-line replacement in a BSD sed?
  27. Regular Expression for any number greater than 0? [closed]
  28. How to change date format in sed?
  29. Regular Expression usage with ls
  30. Finding and removing Non-ASCII characters from an Oracle Varchar2

Leave a Comment