INTERNET Articles: Excel and Google Sheets

All resources related to INTERNET for Excel and Google Sheets.
All articles INTERNET

INTERNET

How to Get a Domain Name from a URL in Excel
In this tutorial, we will learn how to get domain name from URL in Excel. In order to do this, we will use LEFT and FIND functions. Combination of these two functions allows us to get a number of characters to the specific certain character. Figure 1. Final result Syntax...
Get page from URL
To get a page from URL while working on excel spreadsheet, a formula can be used that comprises on many excel functions like SUBSTITUTE, RIGHT, REPT, and TRIM. Formula The formula to get a page from URL in excel worksheet is given below =TRIM(RIGHT(SUBSTITUTE(url,"/",REPT(" ",100)),100)) Explanation Firstly, the above-mentioned formula...
Strip protocol and trailing slash from URL
If you have a URL and want to find a double slash (“//”) and remove the protocol (https://) from it, you will use a formula that combines the MID, FIND and LEN functions. Throughout the article, we will provide you with a complete guide to using this formula. Strip protocol...
How to Get the Top Level Domain (TLD) from Data in Excel
The Top Level Domain (TLD) refers to the last part of the full domain name or URL that follows after the dot “.” symbol, like .com, .net, .org etc. We can extract the top level domain from the full domain name or email address using a formula that consists of...
Create email address from name
There are times when we are required to create email address from name when working with excel spreadsheets. This article provides a quick guide on the process. Figure 1: Example of how to create email address from name General syntax of the formula =LOWER(LEFT(first) & last) “@domain.com” Understanding the formula...
How to Remove a Trailing Slash from a URL Link in Excel
We can remove a trailing slash from a URL LINK by using a combination of LEFT, RIGHT, and LEN functions. This will delete the slash from the URL. We will walk through the steps below to understand how this works. Figure 1: Results of removed slash from URL using the LEFT, RIGHT, and LEN...