How To Join And Split Data In Microsoft Excel


If you need to manipulate data in Excel, this video shows you how to tackle a few key problems!

Excel-Data-ManipulationDoes your data appear in one column when you need it split? Or is it in several columns you’d like to combine? Either way, I will show you how to deal with this and how to move your revised data to a new location. Sometimes when you bring numerical data across you lose the leading zeros, so I demonstrate how to create a custom format to deal with this.


If you found this blog useful, why not sign up to receive my weekly blogs in your inbox?