Say we have in column A a list of names like:
mike
bob
joe
tom
In B1 enter:
=HYPERLINK("http://www.example.com/pics/" & A1 & ".jpg")
and copy down
--
Gary''s Student - gsnu200775
"Noremac430" wrote:
I'm trying to automate a process of automatically creating a hpyerlink so a
web document so that I don't have to manually type out the hyperlink stuff
for every feild.
Example: i want to view a user picture from
http://example.com/pics/username.jpg
where username would be replaced by the info put into the UserID feild.
Be aware that I have no prior programming skills so treat me like a baby
please :-D
I have a feeling this will require some VB but I hope there is a simpler way.
Thanks for the help!