Use Data Validation with No Punctuation in Excel Office 365!!
Tags: datavalidationwithno, excelpreface
Published: 2021-03-19 11:59:56

---
title: Use Data Validation with No Punctuation in Excel Office 365!!
published: true
date: 2021-03-19 10:12:11 UTC
tags: Datavalidationwithno,ExcelPreface
canonical_url: https://geekexcel.com/use-data-validation-with-no-punctuation-in-excel-office-365/
---

In this article, we are going to see how to **use data validation with no punctuation in Excel Office 365** with an example. If you want to avoid punctuation in specific cells, then the below steps will help you to do that. Let’s get into this article. Get an official version of ** MS Excel**  from the following link: [https://www.microsoft.com/en-in/microsoft-365/excel](https://www.microsoft.com/en-in/microsoft-365/excel)

**Check this too:** [Validate only numbers in Cells in Excel 365](https://geekexcel.com/how-to-validate-only-numbers-in-cell-in-excel-office-365/)
## Data Validation with No Punctuation:

To validate data with no punctuation in Excel, you just follow the below steps.

- Firstly, you need to **select the cell or a range of cells** that you want to allow only input values without punctuation.
- For instance, in the below screenshot, we have selected a range **B2:B6**.

![Select the range](https://geekexcel.com/wp-content/uploads/2021/03/1.png)<figcaption id="caption-attachment-22509">Select the range</figcaption>

- Then, you need to enter the punctuations that you want to avoid as shown in the below screenshot. Here, we entered them in a range **C2:C8**.

![Enter the punctuation values](https://geekexcel.com/wp-content/uploads/2021/03/EXCEL_oqgL0tIj4c.png)<figcaption id="caption-attachment-22557">Enter the punctuation values</figcaption>

- Then, you need to **select** the **Data Validation** option under the **Data tab.**

![Data Tab](https://geekexcel.com/wp-content/uploads/2020/12/2-15.png)<figcaption id="caption-attachment-19337">Data Tab</figcaption>

- It will open the **Data Validation Dialog Box** where you need to **click** the **Settings** tab.
- You have to **select** the **Custom** option under the **Allow drop-down**  **list**.
- In the Formula box, you have to **enter** the below-given **formula** and **select** the **input range** using the browse button.

**=[COUNT](https://geekexcel.com/how-to-use-excel-count-function-in-office-365-with-examples/)([FIND](https://geekexcel.com/how-to-use-find-function-in-microsoft-excel-365/)($C2:$C8,B2))=0**

![Data Validation Dialog Box](https://geekexcel.com/wp-content/uploads/2021/03/EXCEL_nLE4gROgdH.png)<figcaption id="caption-attachment-22558">Data Validation Dialog Box</figcaption>

- Now, you need to **hit** the **OK** button.
- Then, you can **enter the input data** in the range.
- If you enter any punctuations, then it will display a warning message as shown in the below figure.

![Output](https://geekexcel.com/wp-content/uploads/2021/03/EXCEL_S7BDJopf3F.png)<figcaption id="caption-attachment-22559">Output</figcaption>

## Wind-Up:

In the above article, we have described the steps to **use data validation with no punctuation in Excel Office 365** with an example. Kindly, give our **suggestions/feedback** in the below comment section. Thanks for visiting **[Geek Excel.](https://geekexcel.com/)**

**Related Posts:**

- [How to Rename Multiple Files using Macros (VBA) in Excel 365?](https://geekexcel.com/how-to-rename-multiple-files-using-macros-vba-in-excel-365/)
- [Excel Formulas to Highlight Bottom Values with Conditional Formatting!!](https://geekexcel.com/excel-formulas-to-highlight-bottom-values-with-conditional-formatting/)