China Naming Network - Auspicious day query - Excel table, write a function to check whether the number of characters in all cells is eight?
Excel table, write a function to check whether the number of characters in all cells is eight?
To check, you only need
Data--Validity--Text length--equal to--8, then click Data Validity again--circle invalid data without distinction. Chinese and English characters, so that invalid data can be represented.
If you have other uses, you can refer to the people above to use the LEN function