I already know ARGK formula, and i didn't like it, i know there is a better way to do it, that why I'm searching the net & ramananhrm formula is too complicated,i thank them for their efforts but that is not what I'm looking for. what you don't know is that in the source file i have more that 20000 values. that what makes there ways is not efficient. let me ask you this i have name in a column & code in another column let say John in A1 & J1 in B1, and you want to combine them in one cell to be shown like this John (B1), how would you do it. I'm asking that because someone send me a vb Formula which work , but i need to move all the 20000 values in source sheet to one cell to be read as John (B1).Thanks