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.
– Rosanne Hubler
• 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?
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.