C
CYNTHIA
I have a ticket number and I need a count within a cell.
I have 2000 lines of tickets and I need to make sure that the count within a
cell does not go over number.
ExampleMust be in this format)
LMN000001234567
KLM000000012345
Some entries of the ticket numbers sometimes are not inputted correctly.
I need highlights to show the wrong entries if there are more zeros in LMN
and KLM. Also if the digits in LMN goes over or under 7 digits and KLM goes
over or under 5 digits. They have to be in this format. If not they are
wrong.
I need LMN to have 5 zeros with 7 digits which means there is not a 0
infront of the 7 digits.
I need KLM to have 7 zeros with 5 digits which means there is not a 0
infront of the 7 digits.
I have 2000 lines of tickets and I need to make sure that the count within a
cell does not go over number.
ExampleMust be in this format)
LMN000001234567
KLM000000012345
Some entries of the ticket numbers sometimes are not inputted correctly.
I need highlights to show the wrong entries if there are more zeros in LMN
and KLM. Also if the digits in LMN goes over or under 7 digits and KLM goes
over or under 5 digits. They have to be in this format. If not they are
wrong.
I need LMN to have 5 zeros with 7 digits which means there is not a 0
infront of the 7 digits.
I need KLM to have 7 zeros with 5 digits which means there is not a 0
infront of the 7 digits.