#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default seperating columns

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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 11,501
Default seperating columns

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Seperating Text from Columns Johnny B[_2_] Excel Discussion (Misc queries) 1 March 28th 07 04:01 AM
Seperating Text from Columns Greg Wilson Excel Discussion (Misc queries) 0 March 28th 07 03:50 AM
Seperating Text from Columns Johnny B[_2_] Excel Discussion (Misc queries) 0 March 28th 07 02:16 AM
Seperating cells and columns DRLski Excel Discussion (Misc queries) 3 September 1st 05 07:02 PM
Seperating of Text in one cell into two columns Mistys template Excel Worksheet Functions 1 January 27th 05 05:06 PM


All times are GMT +1. The time now is 11:32 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"