Extract numbers from cell

**kingsgambit107** · 06-29-2011, 06:20 PM

In column "b" there are two sets of 5 or 6 number within a long character string. I need to extract the set 5 or 6 digit set of numbers that is "not like" the set in column "a". If there is any help, that would be greatly appreciated.

"a"
attx91136
"b"
Air hose separation between the attx91136 and vttx97538. LS

I need a formula that would extract the set of number not like column a, in this case it would be vttx97538.

**martindwilson** · 06-29-2011, 07:25 PM

i think we need some more examples preferably in a sample workbook

**Azam Ali** · 06-30-2011, 04:02 AM

Hi kingsgambit107

The example file is enclosed for your required formula. you could also make nested formual by combining forumula in column E & F into column C.

i am also expectiong a more better solution from the excel experts of this forum.

**Azam Ali** · 06-30-2011, 04:43 AM

There was an error in the previous file. Kindly take the file enclosed with this reply

**kingsgambit107** · 07-17-2011, 01:07 PM

Originally Posted by Azam Ali

There was an error in the previous file. Kindly take the file enclosed with this reply

Thanks Azam! I attached the spreadsheet. I need the set of numeric values that is in column "k" that is NOT in column "a". This is a great help as I have to do several of these daily. If there is not a second set of numerical values in column "k", then it does not have to be segregated.

**zbor** · 07-17-2011, 01:28 PM

Chech this...

However, in K column you need to write EXACTLY as in A column.

For example, in last row, you can not have blanks among desired word:

CREW FOUND AIR HOSE CAME APART BETWEEN CARS TTZX 86377, AND TTZX857425. CREW GOT THE AIR HOSE RECONNECTED AND AIR IS NOW RECOVERED. 0739CST-PMR/OMA