I have a column with street addresses but some of them have a name in front of the address.
How do I remove the non-numeric characters before the first numeric character?
Examples:
Debbie9676 S. Mount Jordan Rd
Ivory Ridge Office3401 N. Center St. #250
June3535 E. Little Cottonwood Ln 84