First off, sorry. Very new to access. I have a table that has street number and street name in the same field. Ex. "131 N Maple Ave". I would like to separate the number and put it in its own field and leave the remaining street name in the existing field. Ex. "131" in the new field, lets call it "streetno" and "N Maple Ave" kept in the existing field. Thank you