vbscript .find ignore spaces

[dillyoh]

I have a script that searches phone numbers

Set rngFind = .Find(What:=Trim(txtLookup.Text), LookIn:=xlValues, LookAt:=xlPart)

Some of the numbers have spaces and some are just numbers.
eg in the database a phone number may show up as "0218888888" or "021 888 888"

Is there a way so when my .find looks for the number it will search both? ignore the spaces?

 

[gallen]

I don't think there is using the 'Find' method. You'd have to write a custom look-up that loops through the data. Could be slow though if there are tens of thousands of rows

 

[steve the fish]

Or have another field in the database which converts the various number combinations to exclude the spaces.