Excel Word Count Validation
1. Data ---> Validation
2. Setting ---> Custom
3. Type the following formula:
=IF(A3="",
0, LEN(TRIM(A3))-LEN(SUBSTITUTE(A3," ",""))+1)<=210
Limit Number of Words in Excel Cell (Excel Word Count Validation)
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment