1

I have a calculated column called SUID # that pulls the value from a single line text input called SUID. The formula in SUID # is:

=RIGHT(LEFT(SUID,INT(FIND("=",SUID)-1)),LEN(LEFT(SUID,INT(FIND("=",SUID)-1)))-1)

If SUID is blank, the SUID # column will show #VALUE!

Is it possible to change that error text? I would like it to say "Please Enter the SUID Only on Package Pickup"

|improve this question
1

It'd be something like this:

=IF(ISERROR(RIGHT(LEFT(SUID,INT(FIND("=",SUID)-1)),LEN(LEFT(SUID,INT(FIND("=",SUID)-1)))-1)),"Please Enter the SUID Only on Package Pickup",RIGHT(LEFT(SUID,INT(FIND("=",SUID)-1)),LEN(LEFT(SUID,INT(FIND("=",SUID)-1)))-1))

http://msdn.microsoft.com/en-us/library/office/bb862071(v=office.14).aspx

|improve this answer
  • This is perfect. I was trying that ISERROR syntax earlier, but couldn't get it right. Thank you! – nicolefdesigns Dec 18 '14 at 15:34
  • @nicolefdesigns kindly tick mark the answer to close the question :) – Arsalan Adam Khatri Dec 18 '14 at 15:35
  • @ArsalanAdamKhatri Since I'm a new user, I have a 5 minute wait time to be able to close the question. I think that is a bit ridiculous, but it can't be helped. – nicolefdesigns Dec 18 '14 at 15:36
  • ^ Yes I observed that feature in the beginning.. I'm sure there will be strong reason for it.. Some new users usually leave the question open even when answered, and closing questions can only be done by questioner so thanks.. :) – Arsalan Adam Khatri Dec 18 '14 at 15:40

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.