
1. Open Excel click on “Data” – “Data Validation” in setting – allow box, drop down the menu and select “Text Length”
2. Insert the minimum and maximum character length for example 1 is minimum and 8 is maximum, you can give any maximum number as per your requirement.
3. Now click on “Input Message” in the title box type “below 8” or type whatever you want.
4. Click on “Error Alert” in error message box, type “Max. text length is 8 character” or anything else. After this click on “Ok”
5. Now the setting has applied if you typed more than 8 character this message will appear and stop you, if you want to apply this setting to other cells just select the cells including setting cell and press “Ctrl+D”
Watch video tutorial… Please like, share & subscribe
2 comments:
chrome hearts online store
golden goose sneakers
golden goose
balenciaga trainers
golden goose
golden gooses outlet
curry 7 shoes
converse outlet
yeezy boost 350
jordan 13
click for more cheap dildo,vibrators,cheap dildo,wholesale sex toys,dog dildo,wholesale sex toys,sex chair,sex toys,cheap dildo sites
Post a Comment