Find Function or Something of the Like

[Hudson]

I am trying to apply a 'Find' Function or something of the like to Column B to completely isolate the 'NPI #:' for the information in Column A - any suggestions?

[Pepe Le Mokko]

If it's the only group of digits in the string this UDF might help

Please Login or Register  to view this content.

[Hudson]

Thanks - can you apply that UDF to my file, I am not sure how to do so. Is that a possibility and then upload the file with the UDF added so I can see how it works with my information?

[Pepe Le Mokko]

Open your file Hit ALT+F11 - Click Insert - Select "module" - Copy paste the code in this module then close the VBA editor.
You now have a new function called "DigitsFirstID" that you can use as any other function, the argument being the string( something like =DigitsFirstID(A2)

[Hudson]

I tried to apply the function - but it doesn't seem to be working - can you see what I did wrong?
Thanks so much!

[Haseeb Avarakkan]

Try this in B2 & copy down.

=IFERROR(LOOKUP(9E+300,MID(A2,SEARCH("NPI #",A2)+7,ROW(A$1:A$15))+0),"")

[Hudson]

Amazing!
Thanks

[James Donovan]

It's really valuable information for me, because I am new in excel.