Hi, I'm in a middle of a riddle, i want to filter the content of a range of cells from the right and from the left, lets say for instance: http://www.myspace.com/mysite.asp and I only want myspace.com to stay alone.
The left part is easy cause its always the same "http://www." which is 11 characters so mid(a2,12,40) will always work.
But i don't know how to deal with the right part cause that part varies from a site to another, and I'm not sure if its possible to find a character like this "/" in myspace"/"mysite.asp, and stop counting.
Please help me out here, I'm out of options.
2007-05-25
08:55:46
·
5 answers
·
asked by
Anonymous