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.
The first method is to simply press Alt+Enter between the values as you are entering the formula. For instance, consider the following formula: In this instance, every place that you see [ae] you would actually press Alt+Enter. Thus, you would end up with a formula that looked like this just before entering it: If you find entering this type of formula distracting, you can always use the actual character code that Excel does whenever you press Alt+Enter. The following formula shows this approach: The CHAR(10) inserts a line feed character, which is the same as is done by Excel when you press Alt+Enter.