Windows 7 Forums

Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.


Windows 7: export txt file from excel help

16 Nov 2010   #1
paul3200

Windows 7 Ultimate X64
 
 
export txt file from excel help

i have tried (and succeeded) to export a txt file from excel 2010 but each column is separated by a tab and i want it to be separated by a "|" character so it can be used in a program i have edited

thanks


My System SpecsSystem Spec
.
18 Nov 2010   #2
clunkfish

Windows 7 Enterprise x64
 
 

You could open the txt file in Word, then do a Find and Replace. The way to find a tab is to use ^t in the find field, and obviously put | in the replace field. Hit "replace all", then make sure to save it as a txt file
My System SpecsSystem Spec
Reply

 export txt file from excel help




Thread Tools





Similar help and support threads
Thread Forum
Export mailing labels from Word into Excel
How to export mailing labels from Word 2010 into Excel 2010 to upload to USPS for bulk mailing
Microsoft Office
How to export Outlook 2010 contacts to Excel?
I want to export all my contacts in Outlook 2010 to Excel. Suggestions? Why: I am fairly sure my outlook file is corrupt. I cannot see my contacts in category view as I did when I had the same program in WinXP (I upgraded to Win7.) After 8 months, the first category appeared in the Current...
Microsoft Office
can't export my msinfo32 file
The process starts fine but when it comes to the display he crashed I've included a picture
General Discussion
Command Line Prompt - How To Export List of Files to Text File
Hi guys, I have a folder with 995 files in it and I'd like to give someone a text file with a list of all these files in it. Is there a way that I can get the command line to send the names of these files to a text file? I tried navigating to the directory and using the DIR command and,...
General Discussion
Export Quicken to Excel 2010
When exporting some of the reports generated in Quicken 2010 to Excel 2010, some headers appear with chinese/japanese characters.:( i.e. http://img5.imageshack.us/img5/4139/chinesetext.jpg. Anybody seen this before??
Microsoft Office
In WLM, how to export the Contact Groups in a .csv file ?
In WLM, how to export the Contact Groups in a .csv file ?
Browsers & Mail

Our Sites

Site Links

About Us

Find Us

Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

Designer Media Ltd

All times are GMT -5. The time now is 08:16.

Twitter Facebook Google+



Windows 7 Forums

Seven Forums Android App Seven Forums IOS App