Thanks for the quick reply Nathan, i have removed all the spaces, change cell wrap text and tried but no luck...can you please advise how to resolve it or is there any other short way to get that formula logic?