excel

  • Thread starter Thread starter shurnel
  • Start date Start date
S

shurnel

I have works 6.0 instaled on a xp system but i want to
upgrade to excel because i have save document as save
type formated text(space delimited)(*prn)and works does
not have this format.
 
First, I don't use MSWorks.

But if that's the only reason for your upgrade, you might want to try this to
see if it works in MSWorks:

In excel, you can concatenate a bunch of cells into one cell. You could use the
=concatenate() function or the & operator:

=a1&b1&c1
will join a1, b1, c1 in one cell.

But if you're shooting for .prn file (fixed width), you could see if you have
these functions available in Works: =left(), =right(), and =text().

Then you could build your own formatted string.

=LEFT(A1&REPT(" ",20),20) & LEFT(B1&REPT(" ",10),10) & TEXT(C1,"000,000.00")

This formula builds a 20 character string padded on the right with the data in
A1.

Then a 10 character string padded on the right from B1.

Then it takes a number in C1 and formats it.

Obviously, your formatting will be different and it might take some playing
around to get it perfekt. But once you do, just keep that formula.

Then copy that column and paste into notepad and save from there.

(Excel's pretty expensive for just this.)

An alternative: You may want to download a 60 meg file from OpenOffice.org. It
might serve you well for even more stuff:

http://www.openoffice.org, also available on a CD

But don't throw away your Works program. You may need to go back and save your
documents as .xls for the other programs to open them.
 
Back
Top