Converting Address from one column to 8 columns

  • Thread starter Thread starter Vijay DSK
  • Start date Start date
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.
 
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?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Split column contents (de-concantenate) 7
Text to Columns Problem 4
Creating emailing list from column of addresses 2
counting blank cells within two columns 2
Address blocks to columns 5
Text to columns 2
text to columns 1
How to covert rows to columns or columns to rows. 11

Back
Top