To create a space-delimited text file that exceeds the 240-character per line limitation, use a macro similar to the following sample macro.īefore you run this macro, do the following: Microsoft support engineers can help explain the functionality of a particular procedure, but they will not modify these examples to provide added functionality or construct procedures to meet your specific requirements. This article assumes that you are familiar with the programming language that is being demonstrated and with the tools that are used to create and to debug procedures. This includes, but is not limited to, the implied warranties of merchantability or fitness for a particular purpose. Microsoft provides programming examples for illustration only, without warranty either expressed or implied.

This behavior occurs because, by design, Formatted Text (Space Delimited) (.prn) files have a limit of 240 characters per line. In effect, line 21 corresponds with line 1, line 22 corresponds with line 2, and so on.

The resulting formatted text file contains lines with the following number of characters: Line NumberĪfter the last line (in this example, line 20), the line numbering starts at 1 for the lines that are wrapped. If several rows on the same sheet contain text beyond 240 characters, the text begins wrapping at the row after the last row that contains text.įor example, consider the following sheet: Cell

Openoffice space delimited file