Viewing a Hyperlink in another cell

[Ben]

I have a list of hyperlinks in one cell and I would like to view the actual hyperlink in another cell.
Example: Cell (A2) Albany Area Chamber of Commerce (Hyperlink: www.albanyarea.org) I want cell A3 to show the hyperlink info.

 

[steve smallman]

Ben,

you need to strip out the text containing the address.
the following will work where the first occurrence
of "www" is in the hyperlink.

=RIGHT(A2,LEN(A2)-FIND("www",A2,1)+1)

Alternatively if all your links are formatted precisely
as shown in your post, you could
substitute "(Hyperlink: " and adjust the +1 at the end to
get the string you want.

Steve

-----Original Message-----
I have a list of hyperlinks in one cell and I would like

to view the actual hyperlink in another cell.

Example: Cell (A2) Albany Area Chamber of Commerce

(Hyperlink: www.albanyarea.org) I want cell A3 to show
the hyperlink info.