Editing text is fast and simple using DocHub. Skip installing software to your computer and make changes using our drag and drop document editor in a few quick steps. DocHub is more than just a PDF editor. Users praise it for its efficiency and powerful capabilities that you can use on desktop and mobile devices. You can annotate documents, make fillable forms, use eSignatures, and send documents for completion to other people. All of this, put together with a competitive price, makes DocHub the ideal option to fill in index in text files with ease.
Make your next tasks even easier by turning your documents into reusable web templates. Don't worry about the safety of your data, as we securely store them in the DocHub cloud.
Hey everyone welcome back. We are looking at the IF formula in excel and in particular, if a cell contains the word amp;#39;mintsamp;#39;, we want to bring back something if thatamp;#39;s true, and if it doesnamp;#39;t contain the word amp;#39;mintsamp;#39; we want to bring back a blank. So to do this we need to combine the SEARCH function and Iamp;#39;ll show you in two easy steps how to get it all in one formula. So letamp;#39;s get started. EQUALS, SEARCH, weamp;#39;re searching for the word amp;#39;mintsamp;#39;, comma, within the cell B4, close brackets, and it comes up with the number six. What that means is it has found the word amp;#39;mintsamp;#39; and itamp;#39;s the sixth character along where we start to find that word mints. Weamp;#39;ll drag the cell down and you can see that in the cells that donamp;#39;t contain the word amp;#39;mintsamp;#39;, it brought back an error, and where it did contain the word amp;#39;mintsamp;#39;