I'm not sure I understand what you have in your cells since any character
can be a separator. Can you show us some examples (vary them as much as
possible) of what is in the cells and how you want them to be split apart?

--
Rick (MVP - Excel)


"Vijay DSK" wrote in message
...
Hi all,
Once again struck with an issue.
Is there any way to split one cell (text) to data to multi columns
(offcourse i know the command "text to columns", based on separator, after
trying that i am writing this. As it was giving single column where there
is
no separator or different separator is given.
Any Ideas would be greatly appreciated.