Selecting labels

[ATY807]

Hello,

I have a column of data which comprise labels varying in format (string or number) and length. I would need only numeric labels with the size of 10 digits copied in a separate column. I would appreciate help with an excel function or VBA that could do that.

Thank you,

 

[Joe4]

Please post a sample of what your data looks like.

 

[ATY807]

Hello,

I have a column of data which comprise labels varying in format (string or number) and length. I would need only numeric labels with the size of 10 digits copied in a separate column. I would appreciate help with an excel function or VBA that could do that.

Thank you,

As shown on the image, only the last three labels on rows 21, 22, and 23 are acceptable. These should be selected and pasted in a separate column. Fewer or less than 10 characters are not acceptable. Only numbers and no space.

 

[ATY807]

Please post a sample of what your data looks like.

Thanks for your reply. Image, and additional notes uploaded

 

[Joe4]

Here is an Excel formula that will only return the strings made up of exactly 10 numbers (example for entry in cell A2):

=IF(AND(ISNUMBER(A2+0),LEN(A2)=10),A2,"")

 

[ATY807]

Here is an Excel formula that will only return the strings made up of exactly 10 numbers (example for entry in cell A2):

=IF(AND(ISNUMBER(A2+0),LEN(A2)=10),A2,"")

It works. Thank you so much.

 

[Joe4]

You are welcome.