ramesh_sm81
07-04-2013, 10:14 AM
Hi All,
I have a problem to find the exact match in cell.
For example in cell A1: Johan sent an email
when I am looking word "em" in cell A1 by using Instr function, the InStr function
recognize the word "email". Problem is that search should match exact word 'em' not 'email'. How can I solve this?
Thanks,
Ramesh
I have a problem to find the exact match in cell.
For example in cell A1: Johan sent an email
when I am looking word "em" in cell A1 by using Instr function, the InStr function
recognize the word "email". Problem is that search should match exact word 'em' not 'email'. How can I solve this?
Thanks,
Ramesh