# Get page from URL

=TRIM(RIGHT(SUBSTITUTE(url,"/",REPT(" ",100)),100))

To extract the page, or the part of a path after the last forward slash (/), you can use a formula based on several Excel functions: TRIM, RIGHT, SUBSTITUTE, and REPT. In the example shown, the formula in C5 is:

=TRIM(RIGHT(SUBSTITUTE(B5,"/",REPT(" ",100)),100))

At the core, this formula replaces all forward slashes (/) with 100 spaces, then extracts 100 characters from the RIGHT and cleans this up with the TRIM function.

The replacement is done with SUBSTITUTE and REPT here:

SUBSTITUTE(B5,"/",REPT(" ",100))

Then, the RIGHT function extracts the last 100 characters of the string returned by SUBSTITUTE.

Finally, TRIM removes all leading and trailing space characters and returns the result.

*Note: the use of 100 in this formula is arbitrary, and represents the maximum number of characters to be found after the final forward slash (/) in the original text. Adjust to suit your use case.*

## Excel Formula Training

Formulas are the key to getting things done in Excel. In this accelerated training, you'll learn how to use formulas to manipulate text, work with dates and times, lookup values with VLOOKUP and INDEX & MATCH, count and sum with criteria, dynamically rank values, and create dynamic ranges. You'll also learn how to troubleshoot, trace errors, and fix problems. Instant access. See details here.