Find_text The textsub-string you want to locate. MidA2Find-A212 That formula says in English Look at A2. To fine-tune the search click on the Options in the right-hand corner of the Excels Find Replace dialog and then try any of the below options.
You can supply a cell reference or type in the string into the formula.
MidA2Find-A212 That formula says in English Look at A2. To search for a specific value in the entire workbook. Here youll need to use the MID formula with the following structure. Determine the position of the dash in A2.