I am the Technical Sales Manager for one of the countries leading specialists in Whole House Automation and Entertainment systems. Below is a blend of my thoughts and opinions about Home Automation and some technical solutions that I have found over the years. For more visit my website www.chrisnew.co.uk.
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.
Labels:
Tips
Subscribe to:
Post Comments (Atom)
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