ExcelBanter - Data Validation

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Data Validation (https://www.excelbanter.com/excel-worksheet-functions/61440-data-validation.html)

Sumit

Data Validation

Hi,

How can i define the condition so that a user can enter the data in
only the following format:

AAAAA1111A, where "A" Represents any character & "1" represents any
number.

Sumit

Gord Dibben

Data Validation

Sumit

See this search result from google.

Validation is for Canadian Postal Code format. You should be able to adapt.

http://snipurl.com/kz3j

Gord Dibben Excel MVP

On 21 Dec 2005 07:23:50 -0800, "Sumit" wrote:

Hi,

How can i define the condition so that a user can enter the data in
only the following format:

AAAAA1111A, where "A" Represents any character & "1" represents any
number.

Sumit

All times are GMT +1. The time now is 06:07 AM.