Forcing Data Entry to Include a Specified Character
Data Validation is an excellent way to control data entry to meet a certain condition.
In this example, suppose you want to insure that a specific character is included in a text entry for a range of cells. In the next picture, you want to enter email addresses so you want to make sure the “
@
” character is included. The following steps show how this can be done.Step 1
Select the range of interest, and from your keyboard press
![SelectRange_Alt_D_L](https://lh3.googleusercontent.com/blogger_img_proxy/AEn0k_u4BqCaZFza64FZ1iUxWROrKXJimOX7_6ythtK_E0TXny954EZsGxbpfYJ4fxJK3-VH-qOXTjsjCtUt-FclS00nRJySGEeAzd4u_0-h2SYNjRwn-S9KJZw0wfq_SkVOerZFIsSux0yoo3SvbUk=s0-d)
Select the range of interest, and from your keyboard press
Alt+D+L
to show the Data Validation dialog box.Step 2
In the Data Validation dialog box:
• Click onto the Settings tab.
• Click the down arrow for the Allow field.
• In the list of allowable categories, select Custom.
![SettingsTab_Allow_Custom](https://lh3.googleusercontent.com/blogger_img_proxy/AEn0k_uM72aRRa2KXVMTqILXzdMVoqqSomp68xWmHTU5xEM__7lI-W3_NSqXq0aqP8i_Ee33sJhKzynBtA_T-t4VFI362KGz99eyBIU3qCQiuqJtXXDXORkHNC7DJ7arjstoeGI6AchWdij9B3_PnFRQ95q-BIY=s0-d)
In the Data Validation dialog box:
• Click onto the Settings tab.
• Click the down arrow for the Allow field.
• In the list of allowable categories, select Custom.
Step 3
In the Formula field, enter the formula that is relative to your selected range.
In this example, that formula would be
![DataValidation_Custom_Formula](https://lh3.googleusercontent.com/blogger_img_proxy/AEn0k_sj-EK9rtF8W52BAwa-gfpbgvWlkXkiwg1zQINcObOmxqjRURNZfr6YuKnyYs5up9arinZwTWALe7FeQoxvioF6spvdsKRvWieykh863Eu-yR06wxxSVIhPW1Str-R9jGWJJXfAXtubZd-gDcCudgz2Ix3--SHHiA=s0-d)
In the Formula field, enter the formula that is relative to your selected range.
In this example, that formula would be
=ISNUMBER(FIND("@",B2))
Step 4
Still in the Data Validation dialog box:
• Click the Error Alert tab.
• Click to enter a checkmark in the box next to “Show error alert after invalid data is entered.”
• In the Style field, from the drop down list, select Stop.
• Enter the text for the Title of the error message you want to convey.
• Enter the text for the error message you want to convey.
• Click the OK button.
![DataValidation_ErrorAlert](https://lh3.googleusercontent.com/blogger_img_proxy/AEn0k_uJNP4_YoMuwG0QDrJY5TASZnL68aw6ZT5M8yuAv6jpZA5dbCU8vlVb3ZGhTCqO6HK0bu31wQf7fflYmAFv3-FNmj0fDlkmTFWORIXrKR4slfo0eae2TkzHfi54yd8G_PzYmIErnPtQigHjS_lII_zOBHUU=s0-d)
#evba #etipfree #kingexcelStill in the Data Validation dialog box:
• Click the Error Alert tab.
• Click to enter a checkmark in the box next to “Show error alert after invalid data is entered.”
• In the Style field, from the drop down list, select Stop.
• Enter the text for the Title of the error message you want to convey.
• Enter the text for the error message you want to convey.
• Click the OK button.
📤You download App EVBA.info installed directly on the latest phone here : https://www.evba.info/p/app-evbainfo-setting-for-your-phone.html?m=1
No comments:
Post a Comment