Extract first second "word" from a Cell..
I need to extract the second "word" from a Cell.
=MID(A1,FIND(" ",A1)+1,FIND(" ",A1,FIND(" ",A1)+1)-FIND(" ",A1)-1)
Perfect. I finally figured out how/why this works...and my brain hurts!
If you like having your brain hurt, you might find this formula
entertaining<g...
=SUBSTITUTE(SUBSTITUTE(A1,MID(A1,FIND(" ",A1,FIND("
",A1)+1),1024),""),LEFT(A1,FIND(" ",A1)),"")
Rick
|