Tuesday, 22 June 2010

Combining Cells in Excel

A while back I was asked if there was a way to combine cells in Excel. The answer is there isn't, what you have to do is write a formula in the destination cell that reads '=A& &B& &C& &...' or you can use the 'Concentiate' function. Either way the cells that you want to combine must still exist as discreet cells you simply add an extra cell to combine the others together in.

1 comment:

  1. Thanks..Its very easy of of combining cells in excel. I was trying from last 15 minute but was getting some error. Let me try it..it seems like it would work great for me :)

    ReplyDelete