How to restrict the input into excel cell to specific formate

[tarun0097]

I need to restrict the excel cell to specific format. the entering data must start with alphabet and may or may not contain number after the that and the data must not contain any special characters

Valid formats:
tarun00197u
tarunkumar345ever


Invalid formats:
4tarun
34tarun
tarun00197%-4u


I am new to excel. please help me.
Thanks in advance

 

[Rick Rothstein]

I need to restrict the excel cell to specific format. the entering data must start with alphabet and may or may not contain number after the that and the data must not contain any special characters

Will this "restriction" be confined to a single column (which one?), a single row (which one?), several columns (which ones?), several rows (which ones) or all the cells on the worksheet? Also, are we talking about just one worksheet (which one?), more than one worksheet (which ones?) or all of the worksheets?

 

[tarun0097]

Dear Rick Rothsten, thanks for the fast reply.

I have 20 worksheets in my excel. I have 2-3 columns in each worksheet.. i have to restrict that columns to the specific formate that i have posted as earlier.


Awaiting for your reply. Once again thanks for ur fast reply...

 

[Rick Rothstein]

I have 2-3 columns in each worksheet..

2-3... it changes on each sheet? We will need a list of sheet names and the columns on those sheets that are to have this restricted format.