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.
Step 2. Select Data from the menu, and then choose the Text to Columns button on the ribbon bar. Related Reading: How to Delete Highlighted Text in Excel. Step 3. Choose Delimited if the text and numbers are separated by punctuation, such as a comma or semi-colon, or by tabs.Choose Fixed Width if the different columns of data line up with one another. Click Next.. Step 4. Select the delimiter from the list or choose Other and type the delimiter for delimited data.hoose Delimited if the text and numbers are separated by punctuation, such as a comma or semi-colon, or by tabs. Choose Fixed Width if the different columns of data line up with one another. Click Next.. Step 4. Select the delimiter from the list or choose Other and type the delimiter for delimited data.