Extract Serial Number from middle of text string when surrounded by spaces

[hilldogwater]

HELP. I am trying to find the right formula to pull out just a document number/serial number out of a string of text.

EXAMPLE:

Cell A3 Contains:
"Refer to WSC.RPP.52-024 for marking requirements."

I want to make a formula that will just return "WSC.RPP.52-024".


It seems to be tricky because it is surrounded by spaces and not unique characters.

What I have now is:

=MID(A3,SEARCH("WSC",A3,1)-1,SEARCH(" ",A3,SEARCH(" ",A3,SEARCH("WSC",A3,1)-0)+0)-SEARCH(" ",A3,1))

But it returns: " WSC.RPP.52-024 fo"



PLEASE HELP!! THANK YOU!!

 

[hilldogwater]

That worked perfectly! Thank you! Good call using the "-" as the unique identifier!

 

[jtakw]

You're welcome, glad it worked for you. Welcome to the forum.