This post will guide you how to **filter values starts with number or letter in one single cell i**n Excel. How do I filter in a list those that begin with number or letter using a formula in Excel.

Table of Contents

## 1. Filter Cells Starts with Number or Letter

Assuming that you have a list of data in range B1:B4 which contain text string values. Ad you want to filter those cells values which are starting from a number or letter. The below steps will show you how to filter the data which starts with numbers or letters only.

**Step1:** select one blank cells in the adjacent Cell B1. And enter the following formula based on the ISNUMBER function and the LETF function.

`=ISNUMBER(LEFT(B1)*1)`

**Note:**Cell B1 is the first cell in your data which you want to filter out values that starts with number or letter.

**Step2:** press **Enter** key to apply this formula.

**Step3:** then drag the **AutoFill Handle **in Cell **C1 **down to other cells to apply the same formula. You would see that if the data starts with a number, then returns **TRUE**. Otherwise, returns **FALSE**.

**Step4:** select the cell **C1** in the helper column, go to **Data** tab in the Excel Ribbon, and click **Filter** button under **Sort & Filter** group. And one **Filter** icon will be added into the Cell C1.

**Step5:** click **filter** icon in the Cell C1, and check **True** to filter out all data that starts with number. Click Ok button.

**Step6:** let’s see the last result:

## 2. Video: Filter Cells Starts with Number or Letter in Excel

This video will guide you through using a formula with the ISNUMBER function and Sort & Filter feature to effectively filter cells that start with a number or letter in Excel.

## 3. Related Functions

- Excel ISNUMBER function

The Excel ISNUMBER function returns TRUE if the value in a cell is a numeric value, otherwise it will return FALSE.The syntax of the ISNUMBER function is as below:= ISNUMBER (value)… - Excel LEFT function

The Excel LEFT function returns a substring (a specified number of the characters) from a text string, starting from the leftmost character.The LEFT function is a build-in function in Microsoft Excel and it is categorized as a Text Function.The syntax of the LEFT function is as below:= LEFT(text,[num_chars])…

## Leave a Reply

You must be logged in to post a comment.