Ticket number count within a cell

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.

Example:(Must 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.
 
K

K. Orland

You've posted in the Microsoft Outlook newsgroup, are you sure this is an
Outlook question?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Adding recognised Zeros 5
Count number of digits in a cell 6
Need 7 digit number with differnt number of leading zeros 10
how to write 1234567890123456789 into a cell with number format 3
Testing length of a number 7
adding zero's to a text cell 2
validation rule for exactly 5 digits, including leading zeros 0
Custom number format 12

Top