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

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

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 for2: export txt file from excel help
Thread Forum
can't export my msinfo32 file General Discussion
can not export all data fields for my contacts as csv file Browsers & Mail
Excel file sizes Microsoft Office
Solved Command Line Prompt - How To Export List of Files to Text File General Discussion
Solved Export Quicken to Excel 2010 Microsoft Office
In WLM, how to export the Contact Groups in a .csv file ? Browsers & Mail
Where is the Excel file created? Microsoft Office

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 04:09 PM.
Twitter Facebook Google+



Windows 7 Forums

Seven Forums Android App Seven Forums IOS App
  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33