Keep or extract only 6 digit number

**Sekars** · 02-06-2017, 09:11 AM

Hello Friends

I need to extract only 6 digits numbers.

Any other content other than 6 digit numbers need to be removed.

Expected results plotted in the Light yellow color cells.

thanks in advance

**Phuocam** · 02-06-2017, 09:20 AM

Try this ...

=IFERROR(INDEX(H:H,SMALL(IF((LEN($H$4:$H$20)=6)*ISNUMBER(--$H$4:$H$20),ROW($H$4:$H$20)),ROWS($J$4:J4))),"")

Ctrl+Shift+Enter.

**Sekars** · 02-07-2017, 03:41 AM

Hello Phucoam

Thanks for this array formula.

It is working fine.

Thanks again.

**JohnTopley** · 02-07-2017, 03:48 AM

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

Keep or extract only 6 digit number

LinkBack

Thread Tools

Rate This Thread

Display

Keep or extract only 6 digit number

Re: Keep or extract only 6 digit number

Re: Keep or extract only 6 digit number

Re: Keep or extract only 6 digit number

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] extract 10 digit number only from text string

Extract first 5 digit number starting from the right

How to extract a 15 or 16 digit number from an email.

[SOLVED] Extract Exact 6 Digit Number From String

Extract 9 digit number from string

[SOLVED] Extract 10 digit number from string

[SOLVED] Extract 2, 3, 4 or 5-digit number from string

Bookmarks

Bookmarks

Posting Permissions