Verify Sponsor Formula with airSlate SignNow

Verify patron formula

welcome to youtubers love Excel number 18 if you want to download this workbook can follow along click on my youtube channel then click on my college sex website link and download the workbook youtubers local cell 17 to 21 hey with it in an earlier video we extracted a date from some text and we used the number 9 because we observed in the set of data here here if this is a little short less this is a big list but we thought we saw 0 0 colon 0 0 colon 0 0 space which was nine characters now I want to show you how to verify that a pattern because you know you don't want to I you don't want to just look through a bunch of data and I it because our eyes always make mistake we want Excel to use logic and formulas functions or various other things to verify that nine because we needed the number nine to extract data now let's look at the formula we created in that earlier video I hit f2 here value left of that cell Len of that cell minus nine now that's the minus nine that we need to verify because if we're going to use that a hard-coded nine like this in a formal you need to verify that that pattern actually exists there are nine characters at the end of this text string that I want to hack off in essence now I want to show you how this works value left in len control enter with that cell selected I want to invoke formula evaluator it's the coolest thing one of the coolest things before we had formula value around on what we did we did a lot of f19 I hear this formula auditing evaluate form in 2003 its tools formula auditing and then evaluate formula now let's look at this let's see how it examines is notice the underline says hey I'm going to look there first to evaluate hey look it's looking at that text string and you can tell it's text string because it's in quotes then next it's going here because it's in the left it says left of this but now we need to say how many characters from the left we need to take we can't just take 10 or nine because this this date varies it could be one character at the beginning or two this total number of characters here for the date could be 10 or nine so that's why when we get to how many characters you want to take from the left you have to say the length of the whole thing minus nine so the length of this whole thing it's looking at the text is 18-9 which is nine now once it's it would work fine if left actually delivered a number but left delivers texts so then you have to use the value function which is programmed to take...