We have an excel workbook that is imported into access, but the Address field is always sent with some garbage data before the actual address. An example is
Is it possible in a query to extract only theCode:LYTZ Mason Mitch - Stand Alone1234 North Main St. Novia, MI 33333
Code:1234 North Main St. Novia, MI 33333