Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I am trying to convert a text file to an excel file using Excel 2003. It
consist of names, address, city and state. My problem is everything (name, address..ect.) is all in column A. Is there anyway to get each thing into a seperate columns so I can have Names in column A, Address in column B and so on. Any help would be appreciated! Thank you! |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi,
I think you would have a better chance of a solution if you posted some sample data but in the absence of that have a look at Data|Text To Columns Mike "sbinva" wrote: I am trying to convert a text file to an excel file using Excel 2003. It consist of names, address, city and state. My problem is everything (name, address..ect.) is all in column A. Is there anyway to get each thing into a seperate columns so I can have Names in column A, Address in column B and so on. Any help would be appreciated! Thank you! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Seperating Text from Columns | Excel Discussion (Misc queries) | |||
Seperating Text from Columns | Excel Discussion (Misc queries) | |||
Seperating Text from Columns | Excel Discussion (Misc queries) | |||
Seperating cells and columns | Excel Discussion (Misc queries) | |||
Seperating of Text in one cell into two columns | Excel Worksheet Functions |