Identify incorrect format

[darkhangelsk]

Hi,

I would like to ask if there's a fastest way to identify incorrect format? like in column A there's a hundreds - thousands of data and i have to make sure they have correct format.
Correct format would be:
TICKET-12345 - (any text here)

So basically i need to identify the incorrect ones. Some are like this - > "TICKET_12344 text" or TICKET-12244 text
for these kind of format i need to highlight it.

Identifying it manually making me sick and eat lot of time. But if someone can help correct direction, that would be great.

Thanks!

 

[KRice]

Fluff, I'm curious about the implementation of the first MID function...would MID(A2,8,5) be strictly correct rather than MID(A2,8,6)? I realize it doesn't matter in this case since the correct format should have a space at position 13, and the 2nd implementation of MID checks for that space.

 

[Fluff]

Glad we could help & thanks for the feedback

 

[Fluff]

@KRice
In this case you could use both. When I was setting it up I did it in stages & included the extra character (ie 6 rather than 5 in the Mid) to check that it wasn't a - (ie missing the space after the number). Although that is redundant as the last part then checks for a " - "

 

[KRice]

Nice solution...thanks for the explanation.

 

[Fluff]

My pleasure ?

 

[denzo36]

No worries. Fluff is the don!!