Forum Discussion
HOW TO INCREASE THE MAXIMUM SIZE FORMULA IN VALIDATION OPTION
I´m trying to restrict a cell in order to validate only IPv4 valid IP addresses, however my formula is so long, I have reached the limit of validation personalized formula size, could i Increase that area?
Please check this blog https://rednectar.net/2019/07/15/validating-ip-address-entries-in-excel/, here is formula suggestion how to validate IP address and compromise 255 characters limit.
To translate formulas in English locale to Spanish one you may use https://en.excel-translator.de/translator/ (if formulas are within Excel file they are translated automatically).
To add file to the post click this icon at the bottom left of the Reply window
9 Replies
Perhaps that could be done by another way, as practically everything in Excel. If you attach small sample file to illustrate what exactly you try to do, someone here could suggest proper solution.
SergeiBaklanCould you explain how to upload a file here?
anyway, below the formula that I want to add to a validation cell in B4
=SI(VALOR.NUMERO(EXTRAE(B4;1;HALLAR(".";B4;1)-1))<256;(SI(VALOR.NUMERO(EXTRAE(B4;(HALLAR(".";B4;1)+1);((HALLAR(".";B4;(HALLAR(".";B4;1)+1)))-(HALLAR(".";B4;1))-1)))<256;SI(VALOR.NUMERO(EXTRAE(B4;(HALLAR(".";B4;(HALLAR(".";B4;1)+1)))+1;((HALLAR(".";B4;H4+1))-(HALLAR(".";B4;(HALLAR(".";B4;1)+1)))-1)))<256;1;0);0));0)
a printscreen of the Sheet:
