=MID($A$2,(ROW()-ROW($A$2)+1)*3-2,3) Copying the formula in below shown cells in column B. The function will help to separate a string into substring in Microsoft Excel.
Go to the worksheet in the workbook that contains the strings that you want to check.Write the below formula in cell C2=ContainsSpecialCharacters(B13)It returns TRUE for the first string since it contains a special character. When you copy the formula down it shows FALSE for B14 string and...