Concatenate

[Flame On]

Anyone able to write/instruct the formula for:
I have lets say 30 rows with internet: which I want to associate wit
the next row which have user names in them.
So for example row A has internet: and row B is (e-mail address removed) an
then there is say 30 rows of these.
Any ideas? I seemed to get close but then lost the plot!
I'm pretty lame with how it operates and the formulas.
Thanks if you can! :

 

[Frank Kabel]

Hi
maybe something like
=A1 & ": " & B1

 

[CLR]

You can Concatenate the two cells, such as =A1&" "&B1 (in cell C1) and copy
it down as far as you have data, but this turns the link into TEXT which
will no longer work as a link............If you want to keep the address as
a link, you could just eliminate column A and put "INTERNET:" as a header
for column B..........

Vaya con Dios,
Chuck, CABGx3

 

[Flame On]

Thank you gentlemen, both useful. Appreciated.
: