| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data Validation
Is there any way, using data validation, to require the value entered in a
cell to start with the letter "H" and contain a total of 5 characters? Thanks, Nate XL2003 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Data Validation
for cell G13: use the 'Custom' option in the data validation and on the
formula line put: =AND(LEFT(G13, 1) ="H",LEN(G13) <=5) "Nate" wrote: Is there any way, using data validation, to require the value entered in a cell to start with the letter "H" and contain a total of 5 characters? Thanks, Nate XL2003 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Data Validation
Nate wrote:
Is there any way, using data validation, to require the value entered in a cell to start with the letter "H" and contain a total of 5 characters? Thanks, Nate XL2003 Suppose Data Validation in Cell F4 Formula is =AND(LEFT(F4,1)="H",LEN(F4)=5) -- Message posted via http://www.officekb.com |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Data Validation
Try this...
=AND((LEN(A1)=5),(LEFT(A1,1)="H")) Place the cursor in a1 cell and select the whole A column then click Data MenuValidationSettingsValidation CriteriaAllowCustom and in Formula paste the above formula. Change cell reference a1 to your desired cell. But at the same time dont forget to keep the cursor in activecell of your desired (cell) reference. If this post helps, Click Yes! -------------------- (Ms-Exl-Learner) -------------------- "Nate" wrote: Is there any way, using data validation, to require the value entered in a cell to start with the letter "H" and contain a total of 5 characters? Thanks, Nate XL2003 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Validation Data using Validation Table cell range..... | Excel Discussion (Misc queries) | |||
| How do I get a Data validation list to select another validation l | New Users to Excel | |||
| data validation invalid in dynamic validation list | Excel Discussion (Misc queries) | |||
| data validation invalid in dynamic validation list | Excel Worksheet Functions | |||
| Data validation with validation lists and combo boxs | Excel Discussion (Misc queries) | |||
Linear Mode
