Converting an "ASCII delimited text format" file into Excel 2007 [Solved]

Converting an "ASCII delimited text format" file into Excel 2007

I am about to spend $200 to buy an ASCII delimited text format file (it's a postal mailing list).

(1) Can I sort the file and print mailing labels directly from this file via Excel? If yes, how is this done?
(2) Or, must I convert the ASCII delimited text format file into a standard Excel 2007 file and THEN sort and print to labels? If yes, how is this done?

Thanks in advance for your help!

Solutions to the Problem Converting an "ASCII delimited text format" file into Excel 2007

Download SmartPCFixer for Free Now

Both process are fairly simple.
Open the TXT file with Excel and use the Test to Columns tool on the Data tab of the Ribbon
You may wish to Google/Bing with "excel 2007 text to columns" to see tutorials and/or videos
 
Once you have the Excel file (with suitable headers - line Name, Street, etc - in row 1) you now usw the Merge feature in Word to make labels (or to print directly to envelopes).
It will take you about an hour to master this method but the time will be well
spent.
Again, a search might help you.
 
Have a go and come back if you get stuck
best wishes

Run CHKDSK
  • Go to the Start button.
  • In the Search box, type "cmd" (without quotes) and press Enter.
  • At the command prompt, type "chkdsk /r /f" (without quotes) and press Enter.
  • Restart your computer.

Recommended Method to Repair the Problem: Converting an "ASCII delimited text format" file into Excel 2007:

How to Fix Converting an "ASCII delimited text format" file into Excel 2007 with SmartPCFixer?

1. Download SmartPCFixer. Install it on your computer.

2. After the scan is done, you can see the errors and problems which need to be fixed.

3. The Repair part is finished, the speed of your computer will be much higher than before and the errors have been removed. You can also use other functions in SmartPCFixer. Like dll downloading, junk file cleaning and print spooler error repair.


Related: Can't Get Admin. Tools To Work In Windows 7, Except Config.sys,Can't Delete Messages In My Deleted Items Folder,Can You Print From Web Browser In Home Netwrek With Windows 8 Or 7 Whitout Having A Server Installed?,Can You Create A Form From A Report? Arghh I Hope So!,Can't Delete A Link In Favorites (Vista IE9),Changing FONT Size On Labels (Office Starter 2010 / Windows 7 ),Chrome Browsers Windows Incorrectly Reported To Be Open,Certificate Error - Cannot Open Adobe Files To Read Unless I Purchase Adobe Professional,Cgi Extensions,Cant See Small Windows Above My Task Bar When I Move The Mouse Over The Explorer Icon In The Task Bar Anymore,Computer Sleeps Immediately Upon Wakeup From Hibernation,Computer Locks On Me And Only Ctrl + Alt + Delete Restores It After Lock Up,Computer Restarts When I Put My Admin Password,Conditional Formatting Highlight Cells If A Date Falls Within A Given Week,Computer Does Not Shut Down When Turning It Off.
Read More: Tech Support: cookies not enabled,How to Fix Error - Convert a Local Profile to a Domain Profile?,[Solution] connection refused in async,Troubleshooting:Controling PDF documents from inside Internet Explorer,[Solved] Constant shut down hangups.,chkdsk cannot continue in read-only mode.,Citrix Go To Meeting Downloader,Changing the range of a named range,Conditional Format Problem...,Connect to my network but no access to internet
[PR]
by RunChkdskUtilit | 2016-09-23 17:30