Hi Tony,
A very practical difference between your F/R code and mine is that your's won't work in paragraphs where there are spaces in the data to be bolded (all of George's examples have these) or where lower-case letters are used before the hyphen (two of George's examples have these).
Also, it is evident from what George has posted that his hyperlinks may not be not formatted as such. Simply reassuring him that:
Quote:
In addition all hyperlihnks copied into a word document are entered as hyperlinks. To activate them you need to hold the Ctrl key down when you click on them.
|
Whether that is so depends on how they're input. If they come from unformatted Excel data, simply pasting them into Word doesn't automatically turn them into hyperlinks. The macro does that.