Thread
:
Isolate text in a long url
View Single Post
#
7
Posted to microsoft.public.excel.worksheet.functions
Harlan Grove[_2_]
external usenet poster
Posts: 1,231
Isolate text in a long url
Harlan Grove wrote...
....
=REPLACE(A1;1;SEARCH("[^/]+$";A1)-1;"")
I'll shorten this before someone else beats me to it.
=REPLACE(A1;1;SEARCH("/[^/]+$";A1);"")
Reply With Quote
Harlan Grove[_2_]
View Public Profile
Find all posts by Harlan Grove[_2_]
Isolate text in a long url