Concatenate

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Flame On - 28 Jul 2004 23:15 GMT

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 jbowman@glenbow.org 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! :

--
Message posted from http://www.ExcelForum.com

Reply to this Message

Frank Kabel - 28 Jul 2004 23:25 GMT

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

Signature

--
Regards
Frank Kabel
Frankfurt, Germany

> Anyone able to write/instruct the formula for:
> I have lets say 30 rows with internet: which I want to associate with
[quoted text clipped - 7 lines]
> ---
> Message posted from http://www.ExcelForum.com/

Reply to this Message

CLR - 29 Jul 2004 00:13 GMT

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

Reply to this Message

Flame On - 29 Jul 2004 16:28 GMT

Thank you gentlemen, both useful. Appreciated.

--
Message posted from http://www.ExcelForum.com

Reply to this Message