so i need to look up about 105 people and get some info on them.

i found an easy way instead of going into their actual information online, i just swap their id number at the end of the url.

but i dont wanna keep going up there and typing it in.

is there a way i can post the multiple URLs with the 105 different IDs, and just click on them one by one to get the info.

kind of confusing.

i have all the IDs in excel, so if there is any way i can do it through that.

11/13/2007 10:19:06 AM

can't you convert them to hyperlinks in excel?

11/13/2007 10:20:56 AM

yeah

somehow get a list of them exported to a notepad file

like

23424
52525
52555
21949
42445

Then, this is the hard part, somehow put some unique character before every line, like a $

so you have:

$23424
$52525
$52555
$21949
$42445

then do a find --> replace, and do replace $ with http://www.url/site/here

11/13/2007 10:21:09 AM

nice.

yeah i was trying to figure out how i can use the replace command.

gg, ill have to put something in from of them i guess.

11/13/2007 10:23:25 AM

what you could try is this

have column B be the numbers and column A be some random character

highlight both columns and copy/paste into notepad

hopefully it would past like this:

$ 234234
$ 259995
$ 525955

then do a find replace for "$ " (notice the space there)

11/13/2007 10:24:43 AM

well i used a letter instead of $ because i just press the letter and the down button, instead of shift and 4.

it went quick.

only problem is now i have the column look with the lines around it, in microsoft word.

so i have all 105 of my links. they just arent highlighted.

im trying to cut the borders from around the links, but im affraid it will delete the whole link.

but its working somewhat.

11/13/2007 10:28:09 AM

ok i fixed that problem, i just needed to press Enter after each link.

thanks for the help god

[Edited on November 13, 2007 at 10:30 AM. Reason : when you ask god for help, he answers. loells]

11/13/2007 10:30:05 AM

the first loel

11/13/2007 1:55:08 PM