Free Project Management Tools - Tutorials,Ebooks and Setups

Watch this video to learn the excel Shortcuts for Formatting the data. these are very useful and helpful in formatting which saves lot of time of yours. If you found this video valuable, give it a like. If you know someone who needs to see it, share it. Leave a comment below with your thoughts. Add it to a playlist if you want to watch it later. For Personalized detail learning, write to  dptutorials15@gmail.com If you found this video valuable, give it a like. If you know someone who needs to see it, share it. Leave a comment below with your thoughts. Add it to a playlist if you want to watch it later. *************************************************************** Read my full article on this:  http://ift.tt/2kB14dh *************************************************************** Subscribe for more Awesome Tutorials:  goo.gl/4T8ePc *************************************************************** Support The Channel via shopping:  http://ift.tt/2jH38PR *************

In this tutorial let us learn about an interesting tool in Excel.With this tool, one can join pieces of text together into a single line and vice versa. Let us consider an example here with text in different cells and now we want to bring this together in a single cell. You may think that we can do this by using the CONCATENATE function but I would be showing the more simpler and smarter way to do this. Did you ever here the Justify function in excel?? Now lets use this tool to perform this trick. Step 1: Select all the text in different cells Step 2: Now extend your selection towards right, so as to accommodate all the text into a single line Step 3: Now in the Home tab of menu bar, in the Fill option's drop down menu select the justify command. Now the text appears in a single row...its simple right... Now lets see the working vice versa. let us break the same text into pieces into different rows Step 1. Select the Row which is having the text, along with so