-
The rules for submitting a Dispute have been clarified. Please make certain you read the rules clarification(s) OR read the full DR rules.
Converting Links to index
- Thread starter aeshi
- Start date
Theres a few ways to do it, I could build a tool that would do it. But you could also easily accomplish this with excel:
Put the full url in column A
In column B use this forumla: =LEFT(A1,SEARCH("/",A1)-1)
This will only work if you dont have the http : //, if you have the http : // then use something like: =LEFT(A1,SEARCH("/",A1,10)-1)
Put the full url in column A
In column B use this forumla: =LEFT(A1,SEARCH("/",A1)-1)
This will only work if you dont have the http : //, if you have the http : // then use something like: =LEFT(A1,SEARCH("/",A1,10)-1)
aeshi
Regular Member
- May 1, 2011
- 394
- 166
Thanks but not worked
Weird, its working fine for me. If you want send me a sample file or list and ill send you a spreadsheet that works
. Or you can use one of the proposed solutions above.