Extract partnumber with 10 digits

[Jimmy Joseph]

I have a list of partnumbers that are having either 10 digit or 13
digit. I wanted to extract only the partnumbers with 10 digit from the
list. How do I do it in excel in a single step?

Thanks in advance.


Jimmy Joseph

 

[Bob Greenblatt]

Try an advanced filter and use =len(a1)=10.

I have a list of partnumbers that are having either 10 digit or 13
digit. I wanted to extract only the partnumbers with 10 digit from the
list. How do I do it in excel in a single step?

Thanks in advance.


Jimmy Joseph

 

[James Bailey]

Or you could try =if(len(a1)=10;a1;"")