Extracting numbers from a cell of 8 or more

[Matty5894]

Hi All,

I came across this great macro which extracts number from a cell separating them by ; (i can use this as delimiter in text to columns)

The issue is now I only want to extract numbers which consist of 8 or more in a row.

Ignoring the numbers of 7 or less! Can anybody help that be great? ^^

Please Login or Register  to view this content.

[jindon]

Different method

=GetNumber(A1,8)

Please Login or Register  to view this content.

[Matty5894]

Hi Jindon,

The formula works great for the first step.

However within a cell text sting there could be 10-40 different instances of an 8 digit number. ideally i would like them separating by ";" also.

Example below

12345678;12345678;12345678;

Cheers

[jindon]

Ahhh OK then

Please Login or Register  to view this content.

[jindon]

Duplicate post

[ashishmehra2010]

Hi Matty,

Try

Please Login or Register  to view this content.

Regards,
AM

[Matty5894]

Cheers Jindon! Worked Great

[jindon]

Good and thanks for the rep.