View Single Post
Old 11-01-2010, 02:58 PM
BrazzellMarketing BrazzellMarketing is offline Windows XP Office 2007
Competent Performer
Join Date: Apr 2010
Location: Galax, VA
Posts: 120
BrazzellMarketing is on a distinguished road

That would work. Here's another option that may give you other manipulation options in the future, and may create less work for you.

Copy and past all the values into notepad. Save as a separate file with a .csv extension (not .txt). This tells the computer it's a comma separated values sheet. That's a simple form of spreadsheet. Open your CSV in Excel. In Excel, it will open your data in two columns, and the commas will have disappeared. Now you can delete an entire column in one stroke, sort by values, do operations, etc. When you save, save as file type CSV. You will then be able to copy the CSV text and paste it back into your word document.
Reply With Quote