Manual file processing could be a cause of your company losing money and your staff members losing interest in their duties. The simplest way to speed up all business processes and enhance your data is to deal with everything with cutting-edge solution like DocHub. Take care of all of your documents and Save Codicil in Excel in a matter of seconds and save more time for relevant tasks.
With DocHub, you have unlimited use of your documents and Templates available for you at any moment. Explore all capabilities right now with your free DocHub account.
Todays video is about flash fill and how you can use it to save yourself a ton of time. So the next time you receive a list of names that you need to split to two columns or get them in proper case or even get their initials, no need to search for crazy solutions or complex formulas. Just use flash fill. This video is brought to you by Excel Essentials for the Real World. Learn Excel from scratch or fill in the gaps to become immediately confident. Discover hidden tips and tricks which get you working smarter, not harder. Click on the link below or type in xelplus.com/courses. Ive prepared a few examples. This is going to give you an idea of the different instances you can apply flash fill. In the first exampleб I have the name of the persons and lets say I need to split them into first name and last name. One option is to use flash fill. All I have to do is type in the first name of the person, drag this down. Whats going to happen by default, were just going to be copying that