CODEWITHSUNDEEP
stringexcelurlsplitexcel-formula
dubesor
dubesor

Reputation: 337

Excel - Remove beginning in URL list in Excel (pull out unique endings)

Working from a large list of URLs that all share the same beginning, how can I strip it down to just the unique endings in Excel 2013 or another tool? (ideally with Excel though)

Here are the examples of my initial strings:

http://www.domain.com/sub-folder-name/country/name/page-title-1
http://www.domain.com/sub-folder-name/country2/another-name/different-page-title
http://www.domain.com/sub-folder-name/country3/name3/even-longer-page-title-like-this

I basically want to remove the beginning http://www.domain.com/sub-folder-name/ from every string in the list - and leave the remainder of the URL, so my list looks like this:

country/name/job-title-1
country2/another-name/different-job-title
country3/name3/even-longer-page-title-like-this

Upvotes: 1

Views: 7436

Answers (1)

asp8811
asp8811

Reputation: 803

Use =RIGHT(url, LEN(url)-number of characters to remove). You can use this formula in a cell, then drag and drop to get your list of unique strings. From there, copy the cells with formulas and paste their values in another column or notepad.

ETA: If you wanted, you could have a cell where you typed in the striung you wanted removed, and then change the formula to =RIGHT(url, LEN(url)-LEN(cell address containing string). That would make the formula more dynamic

Upvotes: 1

Related Questions