Function Problems

How to Filter Excel Text That Begins with Periods

Kushani NimanthikaKushani Nimanthika Oct 16, 2026 869 views

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.

How to Filter Excel Text That Begins with Periods
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 (…).
Before you start

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 (…).

Solution 1Recommended

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.

1
Select a blank cell

Click on the empty cell where you want the filtered results to be displayed.

2
Enter the formula for standard periods

Type the formula =FILTER(A2:A8,ISNUMBER(SEARCH(".",A2:A8))) to extract all text containing a standard period character.

3
Account for the ellipsis 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))).

4
Execute the formula

Press Enter to spill the filtered results into the adjacent cells automatically.

Use the FILTER and SEARCH Functions
Formula Range: Ensure you adjust the range 'A2:A8' in the formula to match the actual range of your dataset.
Solve with WPS Spreadsheet

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. 1. Open your workbook: Launch WPS Spreadsheet and open your existing Excel file.
  2. 2. Apply standard AutoFilters: Navigate to the Data tab and use the Filter button to quickly search for specific characters like periods.
  3. 3. Utilize dynamic arrays: Enter advanced array formulas like =FILTER() directly into cells for complex data extraction.
  4. 4. Save your work: Save the document seamlessly in .xlsx format without losing any formulas or data formatting.
Fully compatible with Microsoft Excel formulas, functions, and file formats (.xlsx).Advanced AutoFilter and dynamic array features to quickly locate specific text patterns.Lightweight architecture ensures fast performance on Windows, Mac, and Linux.Free to use with an intuitive, familiar user interface.
microsoft office alternative - wps office

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.