easy

[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

 

[Don Guillett]

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

 

[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

 

[Don Guillett]

glad to help. "How to create hyperlink automatically"

 

[kyegibbon]

hi one more thing please

Now that I've got the results I want to in my cells, is there anyway o
clearing the code?
i.e. having what is displayed as the actual content of the cell



http://www.website.com/jimmy

instead of

HYPERLINK=("http://www.website.com/"&A10)




beacuse its all gotta be normal text for froogle feeds


thanks again,
ky

 

[kyegibbon]

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

 

[kyegibbon]

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

 

[Peo Sjoblom]

That's what it does

--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com

 

[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?

 

[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

 

[David Biddulph]

(e-mail address removed)

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

If you want the formula to show 6, then Copy, and Paste Special/ Values