Microsoft Office Questions? Ask a IT Expert for Support ASAP
Have you tried "Text to Columns" in the Data ribbon (at least in Excel 2007 and 2010). Select the column with the data, check "Delimited", then press next. Now I am not sure from your description, but there should be a space comma or tab between the data columns. Check the correct delimiter then press finish. Let me know if that works or not.
If you have a different version of excel or that does not work let me know. If you could attach an excel spreadsheet (using the paperclip icon above where you are typing) with two or three examples (obviously you want to protect your information, so replace some of the fields, but spacing and all formatting is critical to keep the same so I can see the format).
So when you copy the data it should all go into column a. Click on the A and the entire column is highlighted.
Click on Data, this makes the Data ribbon appear. Under data tools there is a Text to Columns button. Click on that.
A message box appears, check the radio button next to Delimited. Then click on Next.
On the next screen on the left side half way down is an option box with the heading "Delimiters" remove all check marks then check only "Space". Click Finish.
All of the data is now split across columns.
For the columns you do not want, Click on the letter at the top with the right mouse button and select delete.
There will be some issues, like Sweet Frog, which has a space in it and will get split over two columns. Because of the way the data is formatted, delimited with spaces and using spaces in the fields, Excel has no way to distinguish, which is why a file would normally use commas to separate columns.
What I would do,in the case I had to vendors like Sweet Frog and Bestbuy, I would select the best buy columns and drag them right so that the right most columns (cost) lines up. Then delete the columns I did not want. Of course do no select any cells for the vendor or further left (so leftclick and hold down on the cells to move, release, left click and drag right on the mouse, an outline of where to data is going will be drawn, move the right edge one column right).
I apologize for that. I was underway on a submarine. No comms for those few days.