Food chemicals and additives. Many of these such as MSG, aspartame, food colors, preservatives and others are quite irritating. The nightshade family of vegetables. These include tomatoes, red and white, and other potatoes, but not sweet potatoes, all peppers (both sweet and hot peppers) and eggplant.
Enter a formula to return the character associated with the value in cell A1: B1: =CHAR(A1). Now enter a formula to clean the text in cell B1 and to return the length of the cleaned text. That is, if CLEAN removes the character, the value in column C will be zero; otherwise it will be 1.C1: =LEN(CLEAN(B1)). Now copy the range B1:C1 down the column to row 255.ow enter a formula to clean the text in cell B1 and to return the length of the cleaned text. That is, if CLEAN removes the character, the value in column C will be zero; otherwise it will be 1. C1: =LEN(CLEAN(B1)). Now copy the range B1:C1 down the column to row 255.
Select the cells containing the numbers. If you want to remove the dashes from the entire worksheet, click the Select All button, which is the rectangle between A and 1 in the upper left of the worksheet.To select an entire row or column, click on the number or letter pertaining to that row or column.n Excel 2003 or earlier, go to the Format menu and click Cells.. Go to the Number tab of the Format Cells dialog box. Select Number in the Category box. Change Decimal Places to 0 and click OK.. Open the Find and Replace dialog while the cells are still selected.