Hi I am trying to persuade Excel to merge two horizontally adjacent cells, whilst also merging the contents of them. For example, cell A2 contains "A" and cell A3 contains "B". I want to create one cell which contains "AB". Any suggestions?! Thanks Andy

OK, I've come up with a work around... I copied the two columns into a new spreadsheet, and saved as CSV. The open the CSV in notepad and remove all the commas (using replace "," with "" {blank}) Then save and re-open in excel, and bingo! Just copy and paste new colums into original spreadsheet. Maybe this will be of some use to someone else too!

"For example, cell A2 contains "A" and cell A3 contains "B". I want to create one cell which contains "AB"." If you meant A2 contains "A" and B2 contains "B" and you want "AB" to replace it all then Use the CONCATENATE formula. Using your revised example above in C2 type: =A2&B2 The result in C2 will be "AB" (Without quotes of course) Select C2 and then move your cursor over the bottom right hand corner of C2 so that it changes to a black crosshair and then double click it to drag your formula down to the bottom of the active cells in column B (or drag it down manually). Now, select column C by Right clicking on the "C" at the top of the column and select Copy. Right click on column C again and select "Paste values" (to remove the formulas). Then delete columns A and B. Or use the CSV method you have discovered. With Windows their are usually about five different ways to do things. Regards, Bryan