| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
import text and sort data into excel
I am trying to take a txt file and is able to import it but then the info is
in 1 column underneath each other but i want to divide it into 5 different columns.The info is large over 800 companies divided by name,adress,city,state and telephone number.I want to divide that info into 5 respective columns.I have tried and concateante and then divide it without success. Help will be greatly appreciated |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Is there a way to sort text by frequency within Excel? | Excel Discussion (Misc queries) | |||
| data import and text to columns | Excel Discussion (Misc queries) | |||
| How can I sort duplicate text data in excel? | Excel Discussion (Misc queries) | |||
| I have a Comma delimited text file how do I import in to excel an. | Excel Discussion (Misc queries) | |||
| Can you sort text in a random order in Excel | Excel Discussion (Misc queries) | |||
Linear Mode
