I am doing some google research, and part of the work involves copying/pasting search results into a worksheet.

The problem I'm facing is that when I paste something like:


Cats & Dogs: The Revenge of Kitty Galore (2010) - IMDb
Rating: 3.6/10 - from 3,875 users
Directed by Brad Peyton. Starring James Marsden, Nick Nolte, Christina Applegate. The ongoing war between the canine and feline species is put on hold when they join forces to thwart a rogue cat spy with her own sinister ...
www.imdb.com/title/tt1287468/ - Cached - Similar

It appears as 5 or six individual rows in the worksheet. I need to keep the formatting so that I can see bold text etc.

Any ideas? Thanks!