Hi Tony,

Thanks for your reply. I don't think I explained things clearly first time around, sorry about that.

I'm copying a list of information from a column in excel into Word. Once I have the list of information in Word I want to format the text. However, the list will usually be fairly large - 50 to 100 or so different items. The text that I want bolded will also be different for most of the items so a search and replace would take too long. (Basically, I want everything left of the "-" bolded)

For example:

Original Version: SHAW / CBI - FT (Lex): "CB&I/Shaw: building a powerhouse" http://on.ft.com/Q7y48X

Formatted Version: SHAW / CBI - FT (Lex): "CB&I/Shaw: building a powerhouse" http://on.ft.com/Q7y48X

Original version: YHOO / Third Point - NYT (DealBook): "Levinsohn Confirms That He’s Leaving Yahoo" http://nyti.ms/LZTu7u

Formatted Version: YHOO / Third Point - NYT (DealBook): "Levinsohn Confirms That He’s Leaving Yahoo" http://nyti.ms/LZTu7u

Also, it is not formatted in Excel, so I can't do a paste special for the desired format in Word.

One last thing, when I paste the information into Word I can only get the website to show up as a link if I go back to each line and press the Enter key after the link. Is there another way to do this?

Thanks again for the help!

George