It's only easy if you know how. Pls try to use meaningful subject lines for
the archives.
=HYPERLINK("http://www.website.com/"&A10)

--
Don Guillett
SalesAid Software

"kyegibbon" wrote
in message ...

hi. this is probably an easy question, but please could someone give
some help.

I have a list of names in a column..
in another column i want a list of a website URL, forward slash the
name
for example:
B C
freddy http://www.website.com/freddy
john http://www.website.com/john
rupert http://www.website.com/rupert
anne http://www.website.com/anne

i want the 'C' column to automatically complete when a name is entered
i tried "http://www.website.com/"=B1

but didnt work

thanks if anyone can help
kye


--
kyegibbon
------------------------------------------------------------------------
kyegibbon's Profile:
http://www.excelforum.com/member.php...o&userid=34335
View this thread: http://www.excelforum.com/showthread...hreadid=541032