Hi Experts
I have fiel where I put 10 to 12 digit numbers. The Column is formatted as "##### #####" to give a space to make number readable like in India.
If I input "1234567890" it shows me "12345 67890"
Now I'm using a VBA that searches and return from xLValues. It works perfect if I search...