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 "*".
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.
– Genia Vickrey
• Select your single-column of text to be split
...Check: Delimited.....Click: Next
...Check: Other: ...put the asterisk (*) in the box
...Check: TREAT CONSECUTIVE DELIMITERS AS ONE
...Select the destination for the split text
Does that help?
Reinstall any recently installed or uninstalled application program - Text cells not on filter list
Incorrect installation or uninstallation of a software may also lead to system errors. If you start receiving error: Text cells not on filter list after you install or uninstall an software, then you can try uninstalling or installing that software again to see if it can fix the error or not. The problem Text cells not on filter list may be included in that application.
Reinstall your Operating System
The ultimate solution for error: Text cells not on filter list is to reinstall Windows. This removes all unwanted application that is causing problems, erases adware and other malware, clears out junk files and so on.
A Windows disc is needed for old versions of Windows, but Windows 8 has a built in Refresh option that makes the job easy. Bring up the Charms bar on the right side of the screen and click Settings, Change PC settings. Click Update and recovery, then Recovery. Under Refresh your laptop without affecting your files, click Get started.
Personal files - photos, music and documents - are kept, so it isn't a complete refresh, but it's may be enough for most people. A more powerful option is Remove everything and reinstall Windows. Copy files you want to keep to a USB disk before starting though.
– Perry Younker. Sep.20th
Another Safe way to Fix 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 errors will be shown in the scan result.
2. After the scan is finished, you can see the errors and problems which need to be fixed.
3. The Repair part is finished, the speed of your computer will be much higher than before and the errors have been removed. You can also use other functions in this software. Like dll downloading, windows updating and print spooler error repair.
Tagged: Text cells not on filter list, speed up windows