Hi Everyone,
I have a long list of hyperlinks for which i have converted into text to get hold of the filenames (for example). However, like normal internet addresses, you can't use certain characters and so they are replaced with other characters.
eg:
What%27s on Weetabix.mpg
should be: What's on Weetabix.mpg
Weetabix - Fruit %26 Nut.mpg
should be: Weetabix - Fruit & Nut.mpg
Is there a function already installed in excel that will convert the string back?
Many thanks in advance
RodP
I have a long list of hyperlinks for which i have converted into text to get hold of the filenames (for example). However, like normal internet addresses, you can't use certain characters and so they are replaced with other characters.
eg:
What%27s on Weetabix.mpg
should be: What's on Weetabix.mpg
Weetabix - Fruit %26 Nut.mpg
should be: Weetabix - Fruit & Nut.mpg
Is there a function already installed in excel that will convert the string back?
Many thanks in advance
RodP