• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Selection of cell with only 6 digits number

faizan

New Member
Hi,
Can anyone let me know as I have a column with multiple codes; whereas I have to apply formula only on cell with 6 digits number. Kindly share the formula.

Regards,
 

GraH - Guido

Well-Known Member
Kindly share sample file... As we can't (always) guess what the data looks like, let alone offer a working formula.

Given the test is on cell A2 an test is length being 6 digit and it needs to be a number.... Perhaps this can work :
=IF(AND(LEN(A2)=6 , ISNUMBER(A2+0)) , your formula , "")
 
Top