Address formatting

[WatfordKev]

I am looking to delete / remove leading numbers from address fields. have seen a few solutions but none that really do what I want - for example

• "12 smith street" would become "smith street",
• "234A acacia terrace" would become "acacia terrace"
• "dunromin terrace gardens" would remain as "dunromin terrace gardens"...

 

[VoG]

Try like this

=IF(ISNUMBER(LEFT(A1,1)+0),RIGHT(A1,LEN(A1)-FIND(" ",A1)),A1)

 

[WatfordKev]

My word, that is superb, works like a dream. Thanks very much for this!