Copy/Paste the following into the Type field: to search for ' / ' It may be really hard to count double quotes in smaller screens. Make sure the first argument of FIND has a single quote within two double quotes. Found insidePlace in cell B2: =LEFT(B1,FIND(“'”,B1)1).
Some of these part numbers include a quotation mark (') to signify diameter in inches.
the easiest way to get rid of the triple quotes is to just do it in excel then open it in your favorite text editor (notepadd++ is great for windows) and do a find ''' and replace with ' 0 This topic has been locked by an administrator and is no longer open for commenting. Excel find double quote 0 in Conditional Formatting and copy to the rest of your range to fill all the cells containing quotation marks a color.
