Extract Part of A Text String

S

Savag

New Member
Joined
Jun 23, 2008
Messages
2
I have a spreadsheet full of web page links that include both the domain and page. I want to strip the page information out and then I am going to use the remove duplicate feature to see the number of unique urls I am dealing with.

So the format is like this:

http://%rooturl%/%pageurl%

I believe the easiest way would be to just get everything before the 3rd "/", but I am not very good at Excel so I cant figure out how to do that. The %rooturl% will vary by size quite a bit.

Any help would be greatly appreciated.

Thanks,
Dave
 

Excel Facts

Can you sort left to right?
To sort left-to-right, use the Sort dialog box. Click Options. Choose "Sort left to right"
Sort by date Sort by votes
Dave

Welcome to the MrExcel board!

See if this does what you want. If not, perhaps provide a few more samples (of data that fails with this formula) and the expected results.

Excel Workbook
AB
1http://%rooturl%/%pageurl%http://%rooturl%
Remove Page
 
Upvote 0
Savag said:
I have a spreadsheet full of web page links that include both the domain and page. I want to strip the page information out and then I am going to use the remove duplicate feature to see the number of unique urls I am dealing with.

So the format is like this:

http://%rooturl%/%pageurl%

I believe the easiest way would be to just get everything before the 3rd "/", but I am not very good at Excel so I cant figure out how to do that. The %rooturl% will vary by size quite a bit.

Any help would be greatly appreciated.

Thanks,
Dave
Click to expand...

Hi Dave:

Welcome to MrExcel BOard!

one way ...

<html><head><title>Excel Jeanie HTML</title></head><body>
Excel Workbook
AB
1http://%rooturl%/%pageurl%http://%rooturl%
Sheet1


</body></html>
 
Upvote 0
Thank you both for your time in answering!

Peter I used yours first and it worked perfectly for what I needed. Thanks so much to you and Yogi for being so quick to help.

Now I have to figure out exactly what the string was doing so I can do it myself next time :)

Dave
 
Upvote 0
You must log in or register to reply here.

Similar threads

R
  • Solved
Using conditional formatting to highlight the row of a cell containing specific text.
Replies
4
Views
214
etaf
etaf
C
  • Question
Extracting Specific Fields from multiple PDFs with VBA (Excel 2019)
Replies
1
Views
178
chickyguy
C
Z
  • Question
Extracting all the values using Lookup (including duplicates)
Replies
2
Views
80
Zakky
Z
T
  • Question
"Compile Error: Out of memory" with complex userform and many vba subroutines
Replies
1
Views
183
toole123
T
F
  • Solved
Page Breaks and Subscript out of Range
Replies
1
Views
421
Farscape2020
F

Forum statistics

Threads
1,214,516
Messages
6,119,979
Members
448,934
Latest member
audette89

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top