Excel: Lookup a text within string and return Yes or No if text exists

IF(ISNUMBER(LOOKUP(2^15,SEARCH(“SearchString”,G2))),”Yes”,”No”)

Create Custom List in Excel

Step 1 : Navigate to Excel Options -> Click on Advanced Step 2 : Navigate to General Section -> Click to Edit Custom Lists Step 3 […]

Macro VBA code to delete rows in excel sheet meeting multiple conditions 1. Add a button to a new sheet 2. Right click on button […]

Enable or Disable fill handle in Excel One can turn this option on or off by following below steps: Click the Microsoft Office Button , and then […]