Microsoft Office Forums How to convert a text file to an Excel file with the data format automatically?

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 10-03-2013, 04:27 AM
mradmin mradmin is offline How to convert a text file to an Excel file with the data format automatically? Windows 7 32bit How to convert a text file to an Excel file with the data format automatically? Office 2010 32bit
Novice
How to convert a text file to an Excel file with the data format automatically?
 
Join Date: Oct 2013
Posts: 9
mradmin is on a distinguished road
Default How to convert a text file to an Excel file with the data format automatically?

Hi All,
How Do You Do ?



This is the first issue for me here ..But I very needy answering necessary

How to convert a text file to an Excel file with the data format automatically ?

Thank However greetings,,
Reply With Quote
  #2  
Old 10-03-2013, 04:31 AM
OTPM OTPM is offline How to convert a text file to an Excel file with the data format automatically? Windows 7 32bit How to convert a text file to an Excel file with the data format automatically? Office 2010 32bit
Expert
 
Join Date: Apr 2011
Location: West Midlands
Posts: 981
OTPM is on a distinguished road
Default

Hi
You can import a text file into Excel and specify the delimiters in excel from your text file. As for formatting it will use the default formatting in your worksheet. Follow these steps:
Click on the Data menu in your worksheet.
Click on From Text
Navigate to your text file
Click on Import
Choose Delimited
Click on Next
Choose the delimiter used in your text file
Click on Finish

Hope this helps.
Good luck.
Tony
Reply With Quote
  #3  
Old 10-03-2013, 04:51 AM
mradmin mradmin is offline How to convert a text file to an Excel file with the data format automatically? Windows 7 32bit How to convert a text file to an Excel file with the data format automatically? Office 2010 32bit
Novice
How to convert a text file to an Excel file with the data format automatically?
 
Join Date: Oct 2013
Posts: 9
mradmin is on a distinguished road
Default

Quote:
Originally Posted by OTPM View Post
Hi
You can import a text file into Excel and specify the delimiters in excel from your text file. As for formatting it will use the default formatting in your worksheet. Follow these steps:
Click on the Data menu in your worksheet.
Click on From Text
Navigate to your text file
Click on Import
Choose Delimited
Click on Next
Choose the delimiter used in your text file
Click on Finish

Hope this helps.
Good luck.
Tony
Thank you for your interest
But the final shape appear in an appropriate format
Reply With Quote
  #4  
Old 10-03-2013, 05:12 AM
OTPM OTPM is offline How to convert a text file to an Excel file with the data format automatically? Windows 7 32bit How to convert a text file to an Excel file with the data format automatically? Office 2010 32bit
Expert
 
Join Date: Apr 2011
Location: West Midlands
Posts: 981
OTPM is on a distinguished road
Default

Hi
Can you explain more clearly what you are expecting when you import to Excel from a text file.
Tony
Reply With Quote
  #5  
Old 10-03-2013, 06:46 AM
mradmin mradmin is offline How to convert a text file to an Excel file with the data format automatically? Windows 7 32bit How to convert a text file to an Excel file with the data format automatically? Office 2010 32bit
Novice
How to convert a text file to an Excel file with the data format automatically?
 
Join Date: Oct 2013
Posts: 9
mradmin is on a distinguished road
Default

Quote:
Originally Posted by OTPM View Post
Hi
Can you explain more clearly what you are expecting when you import to Excel from a text file.
Tony
In fact I've got a text file from the DOS system I work it in my work, which is a columns without breaks, such as model and serial and Qty want when converted to Excel file data will be in the form of columns
Reply With Quote
  #6  
Old 10-03-2013, 08:38 AM
OTPM OTPM is offline How to convert a text file to an Excel file with the data format automatically? Windows 7 32bit How to convert a text file to an Excel file with the data format automatically? Office 2010 32bit
Expert
 
Join Date: Apr 2011
Location: West Midlands
Posts: 981
OTPM is on a distinguished road
Default

Hi
As the data already appears to be in columns in your text file have you tried copying and pasting into Excel?
If that does not work is it possible to post a sample of your file so I can take a look.
Tony
Reply With Quote
  #7  
Old 10-16-2013, 10:34 AM
Gary Drumm Gary Drumm is offline How to convert a text file to an Excel file with the data format automatically? Windows XP How to convert a text file to an Excel file with the data format automatically? Office 2007
Advanced Beginner
 
Join Date: Mar 2012
Posts: 86
Gary Drumm is on a distinguished road
Default

For Excel 2010 you could try:
Select your text, and copy it.
Then Paste that into an open Excel Spreadsheet.
Select all (in Excel)
From Data, select Text to Columns.
Follow the steps, and you should be able to preview what you will see.
Excel wants to know what delimiters your data has (such as a comma, or a space).

If you can capture and post a sample of the text, that would be best.

HTH
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to convert a text file to an Excel file with the data format automatically? Cannot Convert Text Cell to number format to be able to sort the data jyfuller Excel 10 06-19-2013 05:31 PM
How to convert a text file to an Excel file with the data format automatically? excel cannot open the file .xlsx because the file format or file extension is not val teddysika Excel 1 11-22-2012 06:06 AM
How to convert a text file to an Excel file with the data format automatically? How to copy automatically data from Excel file to Word file? fuchsd Word 6 10-25-2011 05:52 AM
How to restore original data format - from a .pdf file to Excel columns KIM SOLIS Excel 1 09-18-2011 10:49 PM
Convert a file from HTML to WORD format weblayout view gtselvam Word 0 12-02-2008 03:53 AM


All times are GMT -7. The time now is 06:04 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2019, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2019 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft