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 simpler and smarter way to do this.
Did you ever hear the Justify function in excel?? Now, let's use this tool to perform this trick.
Step 1: Select all the text in different cells
Step 2: Now extend your selection towards the right, so as to accommodate all the text into a single line
Step 3: Now in the Home tab of the 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 let's 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 some multiple rows underneath which shall accommodate the text when splitting
Step 2. once again go to the File option and select the Justify tool from the drop-down menu.
Step 3. You will see the text splitting into different rows.
THAT's IT!!!!!
I believe you must have been thrilled with this awesome trick.
Watch this video tutorial for better understanding:
If you liked this tutorial, share it with your friends. And also you can follow us on Youtube, Twitter and Facebook. We would love to hear from you, Please do comment, suggest or compliment our work and we shall make it better for you. You can write us at dptutorials15@gmail.com
************************************************************
★ My Online Tutorials ► https://www.dptutorials.com
LEARNING RESOURCES I Recommend: https://www.dptutorials.com/resources
Subscribe for more Awesome Tutorials: http://goo.gl/NyAtg2
Support the Channel via shopping: http://ift.tt/2jH38PR
Tools that I use for Vlogging:
• Laptop: http://fkrt.it/AM9ab_uuuN
• Canon 200D Camera: http://fkrt.it/AMz75_uuuN
• Benro Tripod: http://fkrt.it/An1lm_uuuN
• Microphone: http://fkrt.it/A2RHz_uuuN
• Collar Microphone: http://fkrt.it/yL8kdQNNNN
• Screen recorder: https://techsmith.pxf.io/2BMjA
• Boom Arm Stand: http://fkrt.it/ypUD8QNNNN
• Zoom H1 Audio Recorder: http://fkrt.it/ypb7WQNNNN
• Harison Softbox Studio Lights: http://fkrt.it/ypCaRQNNNN
• Chroma Key Green Screen: http://fkrt.it/A3gnb_uuuN
• Background Support Stand: http://fkrt.it/A3cCb_uuuN
• Acoustic Foam Background: http://fkrt.it/ypsGdQNNNN
• USB RGB LED Strip: http://fkrt.it/A3T_5_uuuN
• Wireless Mouse: http://fkrt.it/A3Bqz_uuuN
Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!
***********************************************
You Can Connect with Me at:
YouTube: www.youtube.com/c/dptutorials
G+: http://ift.tt/2kAOpa6
Twitter: https://twitter.com/dptutorials15
Facebook: http://ift.tt/2kfRnDi
BlogSpot: http://ift.tt/2kB14dh
Follow:
www.dptutorials.com
www.askplanner.blogspot.com
Comments