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
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 17:09.
Twitter Facebook Google+ Seven Forums iOS App Seven Forums Android App