Parsing a string

[neverends]

I'm trying to figure out a simple problem. I've looked around th
forum, but can't seem to find exactly what I'm looking for. I want t
take a hyperlink and cut off everything up until the last slash an
assign the remaining string to a variable.

I want to take this string:

Code
-------------------
http://www.something.com/xNet/MainS...RecentlyViewed=true&ItemIndex=14&PgCxtDir=Dow
-------------------

...and end up with this string:

Code
-------------------
Profile.aspx?LID=12345678&RecentlyViewed=true&ItemIndex=14&PgCxtDir=Dow
-------------------


the closest I got was getting everything before the final slash to b
assigned to a variable. I know this is a simple problem, but
appreciate any help as I'm very new to VBA. Thanks in advance

 

[Tim Williams]

See help under

InStrRev - finds the last occurrence of a character in a string

 

[Guest]

Dim s as String, v as Variant, s1 as String
s = "http://www.something.com/xNet/MainSite/Listing/Profile/Profile.aspx?
v = split(s,"/")
s1 = v(ubound(v))
msgbox s1

should work in xl2000 and later.