How to Filter Excel Text That Begins with Periods
Question details
The user needs to filter cells in a spreadsheet that begin with periods (...), but encounters difficulties because the software may convert them into an ellipsis or misinterpret the characters.

- Product
- Excel
- Device & OS
- not provided
- Scenario
- Filtering a dataset to isolate text strings that begin with or contain multiple periods.
- Observed behavior
- Standard text filters or functions fail to find text beginning with three periods, either due to wildcard misinterpretation or because the application auto-corrected the three periods into a single ellipsis character (…).
Check your data source to confirm whether the three periods are typed as three separate dot characters (...) or if they have been automatically converted into a single typographical ellipsis character (…).
Use the FILTER and SEARCH Functions
Combine the FILTER, ISNUMBER, and SEARCH functions to accurately locate cells containing standard periods or auto-corrected ellipses.
This dynamic array formula bypasses standard AutoFilter limitations and accurately extracts text containing periods or ellipses from your source data.
Click on the empty cell where you want the filtered results to be displayed.
Type the formula =FILTER(A2:A8,ISNUMBER(SEARCH(".",A2:A8))) to extract all text containing a standard period character.
If the three periods were converted to a single ellipsis, modify your formula to catch both variants by typing =FILTER(A2:A8,ISNUMBER(SEARCH("…",A2:A8))+ISNUMBER(SEARCH(".",A2:A8))).
Press Enter to spill the filtered results into the adjacent cells automatically.

Use the Standard Filter Command
Apply the built-in AutoFilter tool to search for literal period characters directly without using wildcard escape characters.
Filter Text and Advanced Formulas Easily with WPS Office
WPS Spreadsheet provides powerful data filtering and advanced dynamic array functions like FILTER and SEARCH, giving you full control over your datasets.
- 1. Open your workbook: Launch WPS Spreadsheet and open your existing Excel file.
- 2. Apply standard AutoFilters: Navigate to the Data tab and use the Filter button to quickly search for specific characters like periods.
- 3. Utilize dynamic arrays: Enter advanced array formulas like =FILTER() directly into cells for complex data extraction.
- 4. Save your work: Save the document seamlessly in .xlsx format without losing any formulas or data formatting.

Frequently Asked Questions
Why does my spreadsheet change three periods into a single character?
Most spreadsheet programs, including Excel, have an AutoCorrect feature that automatically converts three consecutive periods (...) into a single typographical ellipsis character (…). This can cause text filters explicitly looking for three periods to fail.
Do I need to use a tilde (~) to search for a period in Excel filters?
No, you do not need a tilde to search for a period. The tilde (~) is only used as an escape character when you need to search literally for wildcard characters, such as the asterisk (*), question mark (?), or the tilde itself (~).
How can I filter text that specifically begins with a period rather than just containing it?
In the standard Filter drop-down menu, choose 'Text Filters' and then 'Begins With...'. In the dialog box, type a period. Alternatively, you can use a formula like =FILTER(A2:A8, LEFT(A2:A8, 1)=".") to extract strings where the exact first character is a period.




