INTERNET Articles: Excel and Google Sheets

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...

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...

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...

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...

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...

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...