[MS_AccessPros] Extracting URL from link

 

I have a spreadsheet which includes hyperlinks. I will be importing
the fields into Access for use on a remote site where the software
will make the 'Page Tile' into a hyperlink by using the URL in
another linked field

I need to extract the actual URL from the hyperlink into a separate field.

For example one existing entry is:

<http://www.rotary9790.org.au/1213/conf/Index.asp>District Conference

I have already extracted the text "District Conference" to a new cell
in another column.

How do I extract the URL?

Many thanks,

Robin Chapple

__._,_.___

Reply via web post

Reply to sender

Reply to group

Start a New Topic

Messages in this topic (1)

Recent Activity:

• New Members 3
• New Files 4

Visit Your Group

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use • Send us Feedback

.

__,_._,___