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.
Itâs easy to remove all whitespace from a string, but youâll typically want to keep a single space between words. Excel's Trim function will remove all but one space between words; however, it cannot remove non-breaking spaces â this requires a combination Excel's Substitute and Trim functions. Open your spreadsheet in Excel and locate the cells containing the whitespace that needs to be removed. Use the Trim function to remove whitespace created from normal spaces. The Trim function requires a single reference to operate. For example, entering =TRIM(A1) without quotes will strip all but single spaces between words from the string  this is a test  in cell A1, leaving this is a test.