Skip to content
Free Excel Tutorials
  • Home
  • Excel For Beginners
  • Excel Intermediate
  • Advanced Excel For Experts

Data Analysis

  • How to Create Area Chart in Excel
  • How to calculate average last N values in a table in Excel
  • How to Create Thermometer Chart in Excel
  • Conditional Formatting Icon Sets Examples in Excel
  • Conditional Formatting Rules in Excel

References

  • How to get address of last cell in range in Excel
  • To count total rows in a range in Excel
  • How to use Excel MMULT Function
  • INDEX function: Description, Usage, Syntax, Examples and Explanation
  • How to use Excel TRANSPOSE Function

Data Validations

  • Excel Data validation don’t exceed total
  • Data validation must not exist in list
  • How To Create Drop-down List in Excel
  • Excel Data validation allow uppercase only
  • Excel Data validation no punctuation

Excel Data validation must begin with

by

Using the example below, this tutorial shows how to create Data validation must begin with in Excel.

Formula

=EXACT(LEFT(A1,3),"XX-")
Explanation

To allow only values that begin with certain text, you can use data validation with a custom formula based on the EXACT and LEFT functions.

In the example shown, the data validation applied to C5:C9 is:

=EXACT(LEFT(C5,3),"MX-")

How this formula works

Data validation rules are triggered when a user adds or changes a cell value.

In this formula, the LEFT function is used to extract the first 3 characters of the input in C5.

Next, the EXACT function is used to compare the extracted text to the text hard-coded into the formula, “MX-“.  EXACT performs a case-sensitive comparison. If the two text strings match exactly, EXACT returns TRUE and validation will pass. If the match fails, EXACT will return FALSE, and input will fail validation.

Non case-sensitive test with COUNTIF

If you don’t need a case-sensitive test, you can use a simpler formula based on the COUNTIF function with a wildcard:

=COUNTIF(C5,"MX-*")

The asterisk (*) is a wildcard that matches one or more characters.

Note: Cell references in data validation formulas are relative to the upper left cell in the range selected when the validation rule is defined, in this case C5.

Post navigation

Previous Post:

COSH function: Description, Usage, Syntax, Examples and Explanation

Next Post:

Excel Data validation require unique number

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Learn Basic Excel

Ribbon
Workbook
Worksheets
Format Cells
Find & Select
Sort & Filter
Templates
Print
Share
Protect
Keyboard Shortcuts

Categories

  • Charts
  • Data Analysis
  • Data Validation
  • Excel Functions
    • Cube Functions
    • Database Functions
    • Date and Time Functions
    • Engineering Functions
    • Financial Functions
    • Information Functions
    • Logical Functions
    • Lookup and Reference Functions
    • Math and Trig Functions
    • Statistical Functions
    • Text Functions
    • Web Functions
  • Excel VBA
  • Excel Video Tutorials
  • Formatting
  • Grouping
  • Others

Logical Functions

  • How to use Excel XOR Function
  • IF function: Description, Usage, Syntax, Examples and Explanation
  • How to use Excel FALSE Function
  • Not Equal To ‘<>‘ operator in Excel
  • SWITCH function example in Excel

Date Time

  • NETWORKDAYS.INTL function: Description, Usage, Syntax, Examples and Explanation
  • Get work hours between dates and times in Excel
  • EOMONTH function: Description, Usage, Syntax, Examples and Explanation
  • How to join date and text together in Excel
  • DAY function: Description, Usage, Syntax, Examples and Explanation

Grouping

  • Map text to numbers in Excel
  • How to randomly assign people to groups in Excel
  • Map inputs to arbitrary values in Excel
  • Group times into unequal buckets in Excel
  • Group times into 3 hour buckets in Excel

General

  • How to fill cell ranges with random number from fixed set of options in Excel
  • How to increase by percentage in Excel
  • List sheet names with formula in Excel
  • Mark Workbook as Final in Excel
  • How to choose page/paper size in Excel before Printing
© 2026 xlsoffice . All Right Reserved. | Teal Smiles | Abbreviations And Their Meaning