Deleting specific characters in cells

[zforzani]

I have a list of URL's. Some of these URL's have a slash at the beginning and/or the end, so they look like either this: ibm.com/ or this: /ibm.com/ or this: /ibm.com

What I need is a formula that will delete all of these slashes and make the text in the cell look like this:

ibm.com

It also has to leave all of the other records intact, as many of the entries are already clean.

[Jonmo1]

Try the substitute function

=SUBSTITUTE(A1,"/","")

[zforzani]

The problem is that some of the URL's are listed as something like this-- ibm.com/index

in which case the slash in the middle needs to stay there. Wouldn't the formula you provided get rid of these slashes as well?

[shg]

Please Login or Register  to view this content.