Hi friends, l am sorry for being late. My aim is just like the operation in the image below. l need a macro to do this in the selected area automatically, otherwise l will have to do it for too much cells manually. l tried the code above but it merged only the numbers, not the cells containing expressions. Thanx again.


excel vba.jpg