Hi
Pauls Macro works fine but there is another way as follows:

1. Enter CTrl+H to display the Search and Replace Dialogue Box.
2. Make sure the "Use WIldcards" box is ticked.
3. In the Find box enter "(^013[!a-z]* )" without the quotes.
4. Click in the replace with box and enter Ctrl+B.


5. Enter Alt+H.

This will replace all instances of AAA/BBB with AAA/BBB.

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.

Good luck.

Tony

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]