Excel 2007 : How to get number of characters matching in two strings starting from left ?

Hi jeet,

Welcome to the forum.

On your example, would there be always a space between first word and second word?

Regards,
DILIPandey

<click on below 'star' if this helps>