Viewing a Hyperlink in another cell

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
Click to expand...
to view the actual hyperlink in another cell.
Example: Cell (A2) Albany Area Chamber of Commerce
Click to expand...
(Hyperlink: www.albanyarea.org) I want cell A3 to show
the hyperlink info.
 
Back
Top