I use Notepad++ for such tasks. After copying the source, I need to do a find and replace on:
1.
Find:
Replace w/: blank
On the first find and replace, make sure you have "Regular expressions" enabled, otherwise it will fail to find the entire string value.
Excel should have this ability.