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.

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