Excel formula: Get page from URL

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 substitute forward slashes by 100 spaces. From Right, it removes 100 characters thereby cleaning this utilizing TRIM function. The substitution is achieved by SUBSTITUTE and REPT like this:

=SUBSTITUTE(B5,”/”,REPT(” “,100))

At that point, RIGHT function removes last 100 letters of the sequence that is provided by SUBSTITUTE. At last, TRIM evacuates all driving and trailing characters and provides the result.

Example

In this example, we have inserted two website links in the input list i.e. B5 and B6. The formula is entered in the C5 of the output list as shown in the figure.

Figure 1 Example to get the page from URL in Excel

Notes

In the above formula, the usage of 100 is subjective.
It speaks to the maximum characters found after last forward “/” in the actual content.

Did this post not answer your question? Get a solution from connecting with the expert.

Another blog reader asked this question today on Excelchat:

Hi, (A) I would like to have the data automatically get pasted from external URL (mentioned in point # B) when the Date appears in column D against which the data is blank ( Open, High, Low, Close, Volume & Turnover) i.e. Cell numbers from E2715 to J2715 (highlighted in Yellow) (B) Reference URL:- https://www.nseindia.com/products/content/equities/indices/historical_index_data.htm (C) From the URL mentioned above:- Select a time period i.e. (From date) & (To Date) as per Date mentioned in the column D against which the data is blank (yellow fields) and then paste it there automatically.

An Excelchat Expert solved this problem in 29 mins!

Hi, (A) I would like to have the data automatically get pasted from external URL (mentioned in point # B) When the Date appears in column D against which the data is blank ( Open, High, Low, Close, Volume & Turnover) i.e. Cell numbers from E2713 to J2713 (highlighted in Yellow) (B) Reference URL:- https://www.nseindia.com/products/content/equities/indices/historical_index_data.htm (C) From the URL mentioned above:- Select a time period i.e. (From date) & (To Date) as per Date mentioned in the column D against which the data is blank (yellow fields) and then paste it there automatically.

An Excelchat Expert solved this problem in 26 mins!