kgbaseball Posted February 12, 2007 Share Posted February 12, 2007 I'm trying to merge 2 adjacent cells to combine into 1 cell while keeping the text in both cells. usually, if you try to merge, it'll only keep the text from the left cell. Basically, I want to go from this: to this, without manually having to type every players' name in manually: Anyone have enough experience with Excel to know how to do it? Link to comment Share on other sites More sharing options...
SESbb30 Posted February 12, 2007 Share Posted February 12, 2007 i think you highlight both and right click and merge should be there. Link to comment Share on other sites More sharing options...
redsox Posted February 12, 2007 Share Posted February 12, 2007 i think you highlight both and right click and merge should be there. Like KG said that would keep only the name in one of the cells. Link to comment Share on other sites More sharing options...
redsox Posted February 12, 2007 Share Posted February 12, 2007 This maybe something that you are looking for though I haven't tried it. http://www.office-addins.com/-excel-addins...lls-wizard.html Link to comment Share on other sites More sharing options...
SESbb30 Posted February 12, 2007 Share Posted February 12, 2007 just copy the name that doesnt say and copy it after. Link to comment Share on other sites More sharing options...
kgbaseball Posted February 12, 2007 Author Share Posted February 12, 2007 Hmm, I have Excel 97, so maybe that's why I don't have the Merge Cells Wizard. Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.