Lou Dufresne
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
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks everyone for your advice. The problem is now solved.
Lou
Lou
Kevin