I was in a rush and ended up doing that one manually. I can make things even more difficult for you now though if you really like a challenge! LOL

Now I have a list about 9000-10000 rows long, close to the same format. I don't want to copy/paste or share the workbook, as it's nothing but names, addresses, phone numbers, email addresses, etc. of our clients. This one has no blank lines in between. The trick to this one is not every entry has the same number of rows. For instance, John Smith may have his name, then company, then address, then city/state/zip, then phone, then email and that's it. Mary Jones though may have her name, company, address, city/state/zip, phone, fax, email, and website. So, I have no way to count how many rows per entry. The only distinguishing characteristic about the new names is names and company names are all in bold. Any ideas on that one?