Hi Jindon

Thanks a lot. It works as I wanted. Can I please ask you to explain few things in your code as I am learning vba? Why did you use 7 after Split function and what is the meaning of SpecialCells(12)?

Thanks again for your assistance.