Quote Originally Posted by NITIN SHETTY View Post
Hi Rick,

Thanks for helping but it is not working for special characters say like abc.. der
That is probably because you did not follow my instructions about array-entering** the formula...

**Commit this formula using CTRL+SHIFT+ENTER, not just Enter by itself.