How to insert hyperlink based on text

PRA007 · #1 11-05-2015, 02:47 AM

I apologize for asking the solution of previously answered question here as I am not able to work around with this.

Please merge it if required.

I have Number like this.

Quote:

US 20150299200

I want to insert hyperlink to it like this way

[/QUOTE]http://pimg-faiw.uspto.gov/fdd/00/2015/92/029/0.pdf[/QUOTE]

I want to find

Code:

([US]{2}) ([0-9]{4})([0-9]{3})([0-9]{2})([0-9]{2})

and insert hyperlink like this.

Code:

([US]{2}) ([0-9]{4})([0-9]{3})([0-9]{2})([0-9]{2})

I want to keep US 20150299200 as it is.

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How to insert hyperlink based on the text	PRA007	Word VBA	3	05-11-2015 01:11 AM
VBA Search Table for Text/Select Text/Insert Hyperlink	sldrellich	Word VBA	3	03-24-2015 01:09 PM
Insert a hyperlink in body of email	ChuckDrago	Outlook	0	06-28-2013 06:51 AM
Insert the Hyperlink and hide all sheets except clicking Hyperlink	PRADEEPB270	Excel	1	02-22-2013 09:47 AM
How to insert a hyperlink in activex textbox	Joe Patrick	Word VBA	1	10-03-2011 06:03 AM