Is this an update you want to apply across an entire table in the database or just case-by-case on a form or something?
Will there ALWAYS be a number at the start? i.e. what if that fields has
The Gables, Hotspur Road
Addresses are quite difficult to clean unless you know they are consistent. You can get software/databases to clean against.