People often need to undo age in text when managing documents. Unfortunately, few applications offer the tools you need to complete this task. To do something like this usually requires alternating between multiple software packages, which take time and effort. Thankfully, there is a platform that is applicable for almost any job: DocHub.
DocHub is a professionally-built PDF editor with a complete set of useful features in one place. Altering, signing, and sharing forms gets straightforward with our online tool, which you can use from any internet-connected device.
By following these five basic steps, you'll have your revised text quickly. The intuitive interface makes the process fast and effective - stopping jumping between windows. Start using DocHub now!
welcome to XL metric number 1080 hey if you want to download this workbook 1079 to 1080 click on the link below the video wow we got a great video here this is the same column of data dump text string with letters and numbers we used in our last video 1079 but this time we want to actually get the numbers after the letters either four or six letters convert them to a date and calculate the personamp;#39;s age now we have an amazing online Excel team and Bill and I can never pronounce names very well bill s zy SZ a YouTube came up with an amazing solution now letamp;#39;s start from the inside of the formula and build it bit by bit now the first thing is I want to notice that when we get our date thereamp;#39;s going to be a few problems the first one is itamp;#39;s not for numbers for a year then two numbers for month and 24 day like we need to use our text formula trick to extract and create a serial number date so thatamp;#39;s the first problem weamp;#39;re going to have to ad