Create account   Log in

Text cells not on filter list

I'm working on an Excel file that has a column of cells with a lot of text.
 I want to split the cell into perhaps several cells in the columns out to the right.
 A common theme in these cells is a series of three asterisks "***" followed by a phrase.
 I want to split the cell contents at each occurrence of the "***".
 The text to columns command allows for one character, not three, so I did a find and replace to replace "***" with "*".
 When I did this, all my text disappeared except for "*".
 I don't
know why this is.

I also notice that when I filter the column, not every cell is showing up in my filter list.
 Also, when I click on one of these "non-filtering" cells, then click on Format Cells, then number, the cell text shows as just a bunch of pound signs "#########".
 For the cells that filter, the text is shown.

Any ideas?  I don't see a way to attach a sample file to this request.

– Rosanne Hubler

Solutions to the Problem Text cells not on filter list


Try this...
• Select your single-column of text to be split
• Data.Text-to-columns
...Check: Delimited.....Click: Next
...Check: Other: ...put the asterisk (*) in the box
...Check: TREAT CONSECUTIVE DELIMITERS AS ONE
...Click: Next
...Select the destination for the split text
...Click: Finish
 
Does that help?

Sfc /scannow command can fix errors - Text cells not on filter list


The sfc command is also known as System File Checker which is a very helpful utility to verify and replace important system files. When it scans the whole system and finds any missing, corrupt or damaged system files, it will replace the problematic files. This can fix the error if the file is provided by Microsoft.

Reinstall your Windows


When you have tried the above methods but can't seem to fix your problem, you can reinstall your Operating System and install a "clean" copy of Windows onto your desktop again. But this should be the last resort to fix your problem, as this will completely erase everything on your hard disk and it will take you a lot of time to reinstall all your software back to your computer. It's very necessary for you to back up all files, pictures and personal information before you do that.

– Doyle Constant. Feb.4th

Another Safe way to Repair the problem: Text cells not on filter list:

How to Fix Text cells not on filter list with SmartPCFixer?

1. Click the button to download SmartPCFixer . Install it on your computer.  Run it, and it will scan your system. The junk files will be shown in the scan result.




2. After the scan is done, you can see the errors and problems need to be repaired. Click Fix All.




3. The Fixing part is done, the speed of your computer will be much higher than before and the errors have been removed.


Tagged: Text cells not on filter list, how to fix errors


Highly Recommended

Windows 10, 8.1, 8, 7, Vista, XP
To repair Text cells not on filter list you need to follow the steps below:
Step 1 Download the registry fixer
Step 2 Install and open the program
Step 3 Scan will begin. The errors will be shown in the scan result.
Step 4 Click Fix All, the errors will be removed
Total downloads: 365,636
Download Size: 4.5MB
Download Time: 52s
Compatibility: Win 10, Vista, 7, 8 & 8.1, XP
Requirements: 300 MHz Processor, 256MB RAM,50MB HDD