Excel Help Please :)

Hi,

I usually know about this stuff, but I can't seem to do a simple command that I would like to do.

I have the IP and Port of a shoutcast server, in seperate cells and I want to have a clickable link out to that page, so here is the command I would have liked to enter.

="http://" + IP + ":" + Port

Obviously the IP and Port are replaced by the cells but how can i do this?


Thanks,

-Hecky

 

Try concatenate that should do it.

 

Can you tell me the specific example please

Thanks,


Hecky

 

Kerry is correct, you need to click = then pick concatenate. Put each cell in its own section and hit ok. This will bring them all together. Then just make it clickable!

 

Aha! It's just =http://&IP&:&Port!

Duh! Adding rep to everyone who helped!

 

Glad it's sorted. I was always awful with Excel, lucky I wasn't the only one around to help, eh? =P

 

The concatenate function can be used the following way:
=CONCATENATE("http://",IP,":",Port)