=FIND(" ",A2,FIND(" ",A2)+1)To find the value of the 3rd space in a cell.
=FIND(" ",A2,FIND(" ",A2,FIND(" ",A2)+1)+1)Using FIND to separate firstname.
=MID(B2,FIND(" ",B2)+1,LEN(B2)-FIND(" ",B2))To carry over state abbreviations.
=IF(LEN(B12)>2,INDEX("""state_abbrev chart""",MATCH("""selected state""",0)),A11)To format districts correctly when prepping House or Assemblies and "At-Large" District shows "1".
=IF(AND(A2="U.S. House", OR(B2="AK",B2="MT",B2="ND",B2="SD",B2="ID",B2="WY",B2="DE",B2="VT"), VALUE(C2)=1),"At-Large",C2)
Index Match - also see MatchIDs
=INDEX(index_match.A$2:A$533,MATCH(B2,index_match.B$2:B$533,0))
