Hi Rick,

Thanks a lot for the code. Its working good for single cell selection.

Am facing small issue hile running this macro.

Input:

Cell A1 contains 3 sentences,
Step1: Am santhosh from Coimbatore.
Step2: Am working as testing Engineer.
Step3: I need solution for this.

Cell A2 contains 3 sentences,
Step1: Am santhosh from Chennai.
Step2: Am working as development Engineer.
Step3: I need solution for this also.

If i select this both cell at a time and run the macro, its going on running without any end point. i need to force close this macro to stop. Can you please please provide solution for this.