Tip: Other languages are Google-Translated. You can visit the English version of this link.
Log in
x
or
x
x
Register
x

or

How to check if first character in a cell is a letter or number in Excel?

This article is talking about checking if the first character in a cell is a letter or number in Excel. Please do as follows.

Check if first character in a cell is a letter or number with formula


arrow blue right bubble Check if first character in a cell is a letter or number with formula


You can apply the following formulas to check if the first character in a cell is a letter or number in Excel.

1. Select a blank cell for placing the checking result, then enter formula =IF(ISERR(LEFT(A2,1)*1),"letter","number") into the Formula Bar, and then press the Enter key. See screenshot:

Note: In the formula, A2 is the cell contains the value you need to check.

2. Keep selecting the result cell, drag the Fill Handle down until all corresponding cells are checked.

You will get a result which displayed as letter if the cell value begins with letter. Otherwise, you will get the result displayed as number as below screenshot shown.

Note: If the first character of specified cell is a special character, please apply the following formula =IF(A2="","",IF(AND(CODE(LEFT(A2,1))>=48,CODE(LEFT(A2,1))<=57),"Number",IF(OR(AND(CODE(LEFT(A2,1))>=65,CODE(LEFT(A2,1))<=90),AND(CODE(LEFT(A2,1))>=97,CODE(LEFT(A2,1))<=122)),"Letter","Other"))) to get the results. See screenshot:


arrow blue right bubbleRelated articles:



Recommended Productivity Tools

Office Tab

gold star1 Bring handy tabs to Excel and other Office software, just like Chrome, Firefox and new Internet Explorer.

Kutools for Excel

gold star1 Amazing! Increase your productivity in 5 minutes. Don't need any special skills, save two hours every day!

gold star1 300 New Features for Excel, Make Excel Much Easy and Powerful:

  • Merge Cell/Rows/Columns without Losing Data.
  • Combine and Consolidate Multiple Sheets and Workbooks.
  • Compare Ranges, Copy Multiple Ranges, Convert Text to Date, Unit and Currency Conversion.
  • Count by Colors, Paging Subtotals, Advanced Sort and Super Filter,
  • More Select/Insert/Delete/Text/Format/Link/Comment/Workbooks/Worksheets Tools...

Screen shot of Kutools for Excel

Say something here...
symbols left.
You are guest ( Sign Up? )
or post as a guest, but your post won't be published automatically.
Loading comment... The comment will be refreshed after 00:00.

Be the first to comment.