On May 21, 8:58*am, gary wrote:
On May 21, 8:20 am, gary wrote:
I've never used VBA. Is there a way to do this in Excel 2007?

On May 20, 8:31 pm, Ayush Jain wrote:
You can use find function of excel to avoid using vba

On May 20, 8:55 pm, gary wrote:
In my example, what is the proper syntax of the find function?

Hi Gary,
Your 2nd column has a huge number and excel is not supporting more
then 15 digit number correctly.
Regards,
Madiya