ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   seperating columns (https://www.excelbanter.com/excel-discussion-misc-queries/209904-seperating-columns.html)

sbinva

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!


Mike H

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!



All times are GMT +1. The time now is 07:38 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com