Hi

Take a look at DataText to Columns

Regards

Roger Govier


S.G.Pillai wrote:
I am in search for the option which is opposite to concatenate. (that is if
we type in different columns it can be combined ) in one column. like that i
am looking for a command in which we type all the text strings will be broken
into different columns
pls help
thanks in advance