Save as space delimited file

By definition, the formatted text file cannot contain more than characters per line. In addition, the formatted text file also contains printer font information. This sample macro does not. This solution is designed to give flexibility when you export to text files. Skip to main content. This browser is no longer supported. Download Microsoft Edge More info.

Contents Exit focus mode. Saves a workbook as Unicode text, a character encoding standard that was developed by the Unicode Consortium. Saves a workbook as a comma-delimited text file for use on another Windows operating system, and ensures that tab characters, line breaks, and other characters are interpreted correctly. Saves a workbook as a comma-delimited text file for use on the Macintosh operating system, and ensures that tab characters, line breaks, and other characters are interpreted correctly.

Saves a workbook as a comma-delimited text file for use on the MS-DOS operating system, and ensures that tab characters, line breaks, and other characters are interpreted correctly. Need more help? Expand your skills. Get new features first. Was this information helpful? Then the Customize Format dialog box is opening. Then a prompt box pops up, please click the OK button.

Now current worksheet is converted to a pipe delimited file. If you want to save all sheets as pipe delimited files, please repeat the above step 6 to 8 to save them individually using a different file name for each. Then you can see values are separated by pipe delimiter as below screenshot shown. Note: The other languages of the website are Google-translated.

Back to English. Log in. Remember Me Forgot your password? Password Reset. Log in. Install the app. If you forgot your password, you can reset your password. JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding. You are using an out of date browser. It may not display this or other websites correctly. You should upgrade or use an alternative browser. Save as Space Delimited file.

Thread starter Marineboy Start date Feb 27, Marineboy New Member. Joined Feb 27, Messages 1.