P praseema Joined Apr 12, 2017 Messages 1 Reaction score 0 Apr 12, 2017 #1 Hi all, I need help to validate that the data in excel column is always a 4 characters alphanumeric only. eg: abc1 ADG2 123R 1we2 2WER 3ER3 etc Kindly help in this by giving function to accomplish this check. thanks in advance.
Hi all, I need help to validate that the data in excel column is always a 4 characters alphanumeric only. eg: abc1 ADG2 123R 1we2 2WER 3ER3 etc Kindly help in this by giving function to accomplish this check. thanks in advance.
Becky Webmistress Joined Mar 25, 2003 Messages 7,424 Reaction score 1,511 Apr 12, 2017 #2 Welcome to the forum LEN(A1)=4 would give you the length, so you could combine it with another formula using AND to only allow letters and numbers.
Welcome to the forum LEN(A1)=4 would give you the length, so you could combine it with another formula using AND to only allow letters and numbers.
