By dsab85 on Wednesday, 15 November 2017
Posted in Kutools for Excel
Replies 1
Likes 0
Views 8.1K
Votes 0
Hello,

I have recently started using your tool, but have a problem that I have so far been unable to solve and was wondering if someone could help me with it. I run a regular report, and one of the columns returns a URL. The URL is identical for all the rows, except for a 6 digit number in it.

Sample of the URL is:

<a href="http://abcdefgh01:8080/ertyu/forms/milkyway/ops-TP+Escalation/Default+Administrator+View/?qual='1'="112327"" target="_blank">112327</a>

The Part I am interested in is the 112327, and ideally I would want to replace the URL's with only the number from those URL's. How would I be able to achieve that?

Thanks,
dsab85
Hello,
Sorry, we don't have such function yet.
·
6 years ago
·
0 Likes
·
0 Votes
·
0 Comments
·
View Full Post