Copy cells based on number of number of digits in a code

[curlisdave]

Hi there,

I have a problem I cant quite figure out - I have two columns A & B running to 29,000 rows! In A I have codes ranging in length from 1 digit to to 7 digits. In column B are descriptors for each code.

i would like to extract to two new columns the 5-digit codes and their descriptors ONLY. Is there an easy way I can do this?

Many thanks in advance, if anyone can help.

David

 

[Joe4]

Welcome to the Board!

An easy way of doing it would be to do the following:
1. Add a formula in column C that returns the length of the codes in column A, i.e.
=LEN(A1)
2. Then either sort or use Filters on column C to segregate the 5 digit codes.

 

[curlisdave]

Oh wow, a very simple and elegant way to do it! thank you so much!

 

[Joe4]

You are welcome.
Glad I was able to help!