Hi All,
I have a URL in a cell, and I want to return the value in the node before the .html using an excel formula.
the last node will always be delimited as follows:
/41568362.html
-379636081.html
leading / or -
6-9 digits
.html
The .html might be followed by parameters (such as ?absrc=rdm)
Any help with this would be greatly appreciated
Eric
I have a URL in a cell, and I want to return the value in the node before the .html using an excel formula.
the last node will always be delimited as follows:
/41568362.html
-379636081.html
leading / or -
6-9 digits
.html
The .html might be followed by parameters (such as ?absrc=rdm)
Any help with this would be greatly appreciated
Eric