Converting Address from one column to 8 columns

V

Vijay DSK

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.
 
R

Rick Rothstein

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?
 
Top