Is there a formula I can use to check a cell for a specific format?
For example, I want to check that the first three characters are letters, followed by four numbers. So the first example below would be a positive match and the second would not. Similar to using "format" in VBA.
ABC1234
ABCD123
For example, I want to check that the first three characters are letters, followed by four numbers. So the first example below would be a positive match and the second would not. Similar to using "format" in VBA.
ABC1234
ABCD123