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.

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" <(E-Mail Removed)> wrote in message
news:E9F8E969-8764-40D4-BAC0-(E-Mail Removed)...
> 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.