Search and Replace help

hello all i had a quick question reguarding the Search and Replace function.

First i have a colum that is filled with address information however when it was exported from the database the address was filled with 5 numbers reguardless if there was 5 numbers in the address or not, if there was not 0's were added in front of the numbers to compensate for this:

Ex:

90 W Hopper Way = 00090 W Hopper Way (when exported)
1342 N Uptown Blvd = 01342 N Uptown Blvd (when exported)

My question is does anyone know the wildcard for the Replace part of the function? i am aware that ? and * are both wildcards for Search but i want to retain the original values in the replace field with a wild card and eliminate the 0's.

Anyone have an idea's?

Thanks in advance for your help on this issue

-Conor

Hi,

Or put into one formula*:

=VALUE(LEFT(A1,5))&" "&TRIM(MID(A1,SEARCH(" ",A1)+1,25))

Cheers,

Robert

* Change the number of characters (I've put in 25) to match the maximum number of characters available from the databases' address field.