I Need Help With Microsoft Excel 2007?

there is a way to do it in excel, but cant remember exactly how. i do know that you can use notepad to do it though. make sure that you have two blank columns to the right of the one that has the data in it. in the first one, type PVT.LTD, then drag it down so that you have that in all cells in that column. then highlight both columns. if you dont know how to do this, assuming that they are columbs A and B, you hit the A, then hold SHIFT and hit the B. Both columns should not be highlighted. you then copy via right click, or the edit menu. then open notepad and paste. the result should be the two columns with a tab in between them. highlight one of the tabs, then go to edit and cut. then go to edit and replace. past the tab in the "find what" field. you have to past because if you just hit a tab here it will then just move to the next field. then hit "replace all" to replace all the tabs with nothing, which will delete all tabs. then do edit, select all and copy. go back to excel and click on the first cell in the 3rd column which should still be blank, and past. the result should be the new column has the other two merged. hope this helps.