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"...

Thanks in advance for any help you can give!

[watfordkev]

Got a great answer for this - worked like a dream

For anyone else looking for similar

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

[pike]

or maybe a UDF

Please Login or Register  to view this content.

[pike]

should have been

Please Login or Register  to view this content.