.The solution can split 2words......is there any function that can do the exact reverse function of"concatenate" or that of text to column in the main menu.....I needed a functionthat can be used in the sheet as per my requirement....