Have you ever struggled with editing your Xls document while on the go? Well, DocHub comes with an excellent solution for that! Access this online editor from any internet-connected device. It allows users to Adapt identification in Xls files rapidly and whenever needed.
DocHub will surprise you with what it provides you with. It has powerful capabilities to make whatever changes you want to your paperwork. And its interface is so simple-to-use that the whole process from start to finish will take you only a few clicks.
Once you complete adjusting and sharing, you can save your updated Xls document on your device or to the cloud as it is or with an Audit Trail that includes all adjustments applied. Also, you can save your paperwork in its original version or transform it into a multi-use template - accomplish any document management task from anywhere with DocHub. Subscribe today!
welcome to XL magic trick number 311 hey if you want to download this workbook and follow along click on my youtube channel and click on my college website link and you can download the workbook man district 30 7 to 3 15 in this video we have some product codes from another company and here are our prefix and we need to check through this list and find out is this one one of these so really its a logical formula we need we need to say are the first three characters of this equal to this or this or this or this so heres how well do it and Ill show you a couple different ways to do it the first a long way and then a short away and then an a variant on that hey this is three logical test so well use the or function equals or and origins takes as many logical test up to I think its 255 if any one of them comes out to be true or will report true to the cell so were going to say equals are just left left of this comma 3 that way itll always extract the first three characters which is