seperating columns

S

sbinva

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!
 
M

Mike H

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
 

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

counting blank cells within two columns 2
How to combine three columns information 5
transpose 1 column of 100 items to 10 x 10 array 2
Convert a Word address label file to an Excel spreadsheet 2
Address Recognition and Separation 3
How do you transfer Labels in Word to Excel? 1
remove comma and text past it in cell 2
Merging Data Into Spreadsheet 2

Top