To find the value of the 2nd space in a cell.
%%=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))%%