2) Kelly, I had posted a reply to your query about removal of spaces. Did it work? Use the replace command to get rid of the spaces and then compare. As for the capital characters problem, convert everything in address2 to uppercase using ucase.
1) Do you need to pad the 9 digit number with zeros to make it a 12 digit one or just need spaces every 4 digits and leave it as is. What I mean is a)'8428 1485 9' or b)'8428 1485 9000'