thanks guys for your help.meanwhile i did it with spreadsheet.i just tried the last solution using notepad and it worked like a charm but for one specific url with diffeent anchor.what if i have few different url and i want to asign to them specific anchor and make hyperlinks from it, using notepad++.by the way what is r\n? is it part of a regex or smth?
thanks