easy

K

kyegibbon

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

I have a list of names in a column..
in another column i want a list of a website URL, forward slash th
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
ky
 
K

kyegibbon

sorry about that, couldnt think of how to describe the question.
thanks alot ive got it now,
its for making a froogle listing se
 
K

kyegibbon

*by the way, im just using these names as product examples, im no
actually pimping jimmy and co on froogl
 
K

kyegibbon

*by the way, im just using these names as product examples, im no
actually pimping jimmy and co. on froogl
 
K

kyegibbon

no i meant the actual content to be what is displayed.
if you click on the cell, and look in the = textbox in the top toolbar
it's still going to contain the formula, i want it to just contain the
result of the formula if you know what i mean?
 
D

Don Guillett

I don't know what you mean
if you put in a formula =2*3, in the formula box that is what you will see.
In the cell you will see 6
 
Top