I’ve got so much data that it slows my system to a crawl to copy everything to the clipboard and then paste in the values. I’d rather not do this in chunks. Is there another way to remove the formulas from cells and just keep the values? Perhaps a VBA solution?
I need the code to recognize _ (underscore) and then make columns in Excel based on this.
Christmas Tree – Orkut Scraps and Greetings

Let It Snow – Orkut Scraps and Greetings

Christmas Love – Orkut Scraps and Greetings

Merry Christmas – Orkut Scraps and Greetings

Elf – Orkut Scraps and Greetings

Christmas Stocking – Orkut Scraps and Greetings

Happy Holidays – Orkut Scraps and Greetings

Christmas View – Orkut Scraps and Greetings

sources : www.orkutnow.com