Link to home
Start Free TrialLog in
Avatar of Lou Dufresne
Lou DufresneFlag for United States of America

asked on

Show Hyperlink in separate Column

I have a spreadsheet with a Hyper Link and Title of the hyperlink in column "A" and I want to show the actual URL code in Column B by Referencing the data in Column A. There will be approximately 200 lines of Hyperlink with Titles in Column A

Example:   Column A                           Column B
               Engineering Alloction             http://hdc.www.uprr.com/hdc/rpts/crew/mr0010.snp

What code or statement do I need to place in the Column B cells to show just the link from column A.


Thanks in advance,

Lou
ASKER CERTIFIED SOLUTION
Avatar of zorvek (Kevin Jones)
zorvek (Kevin Jones)
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
If you are unfamiliar with VBA, you can add user defined functions by pressing Alt-11, Insert -> Module, past the above code in the code window, Alt-11 again to return to your worksheet and then enter the functions in a cell.

Kevin
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Lou Dufresne

ASKER

Thanks everyone for your advice. The problem is now solved.

Lou