df = data.frame(name_and_address = c("Mr. Smith12 Some street",
"Mr. Jones345 Another street",
"Mr. Anderson6 A different street",
"1 digit is at the start",
"No digits, sorry."))
df$name <- sub("^(?:(\\D*)\\d.*|.+)", "\\1", df$name_and_address)
df$address <- sub("^\\D*(\\d.*)?", "\\1", df$name_and_address)
df$name
df$address
ZGYgPSBkYXRhLmZyYW1lKG5hbWVfYW5kX2FkZHJlc3MgPSBjKCJNci4gU21pdGgxMiBTb21lIHN0cmVldCIsCiAgICAgICAgIk1yLiBKb25lczM0NSBBbm90aGVyIHN0cmVldCIsCiAgICAgICAgIk1yLiBBbmRlcnNvbjYgQSBkaWZmZXJlbnQgc3RyZWV0IiwKICAgICAgICAiMSBkaWdpdCBpcyBhdCB0aGUgc3RhcnQiLAogICAgICAgICJObyBkaWdpdHMsIHNvcnJ5LiIpKQoKZGYkbmFtZSA8LSBzdWIoIl4oPzooXFxEKilcXGQuKnwuKykiLCAiXFwxIiwgZGYkbmFtZV9hbmRfYWRkcmVzcykKZGYkYWRkcmVzcyA8LSBzdWIoIl5cXEQqKFxcZC4qKT8iLCAiXFwxIiwgZGYkbmFtZV9hbmRfYWRkcmVzcykKZGYkbmFtZQpkZiRhZGRyZXNz