Hi,

Am Tue, 3 Nov 2015 22:48:30 +0000 (UTC) schrieb tb:

For instance, if the part number is:

6520-456-789 STAINLESS STEEL NUT

I would like the formula to extract the STAINLESS STEEL NUT part
because that is what follows the double space in the complete string.

try:
=MID(A1,FIND(" ",A1)+2,99)


Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional