sapxl
New Member
- Joined
- Jun 20, 2020
- Messages
- 24
- Office Version
- 2016
- 2013
- 2011
- 2010
- 2007
- Platform
- Windows
Dear friends,
my query is - After underscore (_) only 10 digits and not accept less than or more than 10 digits entered, it should give alert... Is there any formula combination like- IF LEN,RIGHT function to do this work.. Appreciate your help…
From the above examples, it is taking the characters _ and other characters along with the digits to complete 10 digits display… in right formula, is it possible to restrict before _(underscore) only allow 10 digits not less or more than 10 digits….
eg: meenr_product004_8403465 ---- last numbers 10 digits to be allowed to enter after the underscore if less than 10 digits then it should give me error message like ïncomplete number etc..
I'm trying with the below functions but did not get any result so far...
=RIGHT(D9,10)
=LEN(E8)
=IF(D5 = "_", RIGHT(D5,10), "NUMBER NOT VALID")
=(RIGHT(D5, FIND("_",D5)))
=LEN(RIGHT(D5, FIND("_",D5)))
Please see the screenshot in attachments...
Thanks in advance.
my query is - After underscore (_) only 10 digits and not accept less than or more than 10 digits entered, it should give alert... Is there any formula combination like- IF LEN,RIGHT function to do this work.. Appreciate your help…
From the above examples, it is taking the characters _ and other characters along with the digits to complete 10 digits display… in right formula, is it possible to restrict before _(underscore) only allow 10 digits not less or more than 10 digits….
eg: meenr_product004_8403465 ---- last numbers 10 digits to be allowed to enter after the underscore if less than 10 digits then it should give me error message like ïncomplete number etc..
I'm trying with the below functions but did not get any result so far...
=RIGHT(D9,10)
=LEN(E8)
=IF(D5 = "_", RIGHT(D5,10), "NUMBER NOT VALID")
=(RIGHT(D5, FIND("_",D5)))
=LEN(RIGHT(D5, FIND("_",D5)))
Please see the screenshot in attachments...
Thanks in advance.