Getting complete power over your files at any moment is crucial to alleviate your daily duties and improve your efficiency. Accomplish any objective with DocHub tools for document management and practical PDF editing. Gain access, change and save and incorporate your workflows with other protected cloud storage.
DocHub provides you with lossless editing, the opportunity to use any formatting, and safely eSign papers without having looking for a third-party eSignature option. Obtain the most of the file management solutions in one place. Consider all DocHub functions right now with the free profile.
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