I have to enter the text in multiple lines of text in the format: "500387156;500345678;500123456". The validation criteria is :
=OR(LEN([NOTIFICATION NO.])=0,AND(LEN([NOTIFICATION NO.])=9,MID([NOTIFICATION NO.],1,3)="500",ISNUMBER([NOTIFICATION NO.]+0),ISERR(FIND(".",[NOTIFICATION NO.])),ISERR(FIND(",",[NOTIFICATION NO.])),ISERR(FIND("$",[NOTIFICATION NO.])),ISERR(FIND("+",[NOTIFICATION NO.])),ISERR(FIND("-",[NOTIFICATION NO.])),ISERR(FIND(" ",[NOTIFICATION NO.]))))
Using this criteria, I could enter only one number ("500387156"). Now, required to enter in the format "500387156;500345678;500123456".