Windows 7 Forums


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
North Somerset, UK
 
 

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 problems?



Thread Tools



Similar help and support threads for: export txt file from excel help
Thread Forum
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


All times are GMT -5. The time now is 04:49 AM.


Seven Forums Android App Seven Forums IOS App Follow us on Facebook

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
  

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