I am not able to understand the wildcard string used by macropod. Will it search for all text that precedes the "-" as desired by George?

Also, he wants to convert all urls into hyperlinks without having to go to each url and pressing enter or a space. If you just cut and paste a url in Word it does not convert it into a hyperlink unless you type a space after it. George is transferring data from Excel to Word, and so the urls may remain as plain text. So I think George's problem is not fully solved.

Tony's Find and Replace will work only if the text to be bold formatted is all caps, but from the sample text George has posted, this is not true always.

George requires a more comprehensive code that will convert all text preceding "-' into bold and converting urls into hyperlinks. At least, that is how i have understood his message.

If you pasted George's examples into Word as unformatted text and ran the macro, you would find it does all that George requires.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]