If you can use some character (e.g. space) as a separator, you can use Tools
- text to columns - Delimited... Select the column first.

Aa

"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