hilldogwater
New Member
- Joined
- Jun 7, 2016
- Messages
- 6
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!!
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!!