V Vish Oct 6, 2003 #1 Hi Folks? How to Merge two column values in MS Excel 2000 into one column? Thanks, Vish
K Ken Wright Oct 6, 2003 #2 When you say Merge - You do mean merge as opposed to add?? Assuming so:- A1 = Fred B1 = Bloggs =A1&B1 >>> FredBloggs =A1&" "&B1 >>> Fred Bloggs =A1&"-"&B1 >>> Fred-Bloggs etc
When you say Merge - You do mean merge as opposed to add?? Assuming so:- A1 = Fred B1 = Bloggs =A1&B1 >>> FredBloggs =A1&" "&B1 >>> Fred Bloggs =A1&"-"&B1 >>> Fred-Bloggs etc
