Editing xls is fast and simple using DocHub. Skip installing software to your laptop or computer and make adjustments with our drag and drop document editor in just a few quick steps. DocHub is more than just a PDF editor. Users praise it for its convenience and powerful features that you can use on desktop and mobile devices. You can annotate documents, generate fillable forms, use eSignatures, and email records for completion to other people. All of this, combined with a competitive price, makes DocHub the ideal option to fill in initials in xls files with ease.
Make your next tasks even easier by converting your documents into reusable templates. Don't worry about the protection of your information, as we securely keep them in the DocHub cloud.
Todayamp;#39;s 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. Iamp;#39;ve 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 letamp;#39;s 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. Whatamp;#39;s going to happen by default, weam