Results 1 to 7 of 7

20031120, 19:19 #1
 Join Date
 Jul 2002
 Location
 Pittsburgh, Pennsylvania, USA
 Posts
 11,225
 Thanks
 14
 Thanked 342 Times in 335 Posts
Re: Excel to Fixed Format .txt (2002)
You could use something like this formula to format it a line and then copy it down the column. Then copy pastespecial values then only save this column as a text file.
=+"/"&REPT(REPT(" ",10)&"/",3)&RIGHT(REPT(" ",10)&D1,10)&"/"&RIGHT(REPT(" ",10)&TEXT(E1,"0.0"),10)&"/"&RIGHT(REPT(" ",10)&TEXT(F1,"0.0"),10)&"/"&RIGHT(REPT(" ",10)&TEXT(G1,"0"),10)&"/"
Steve

20031120, 22:24 #2
 Join Date
 Jan 2002
 Location
 Waukegan, Illinois
 Posts
 8
 Thanks
 0
 Thanked 0 Times in 0 Posts
Re: Excel to Fixed Format .txt (2002)
Steve, thanks for the help. i'll tinker with that a little but it sure seems like it may do the trick
This place Rocks

20031121, 06:19 #3
 Join Date
 Feb 2003
 Posts
 363
 Thanks
 0
 Thanked 0 Times in 0 Posts
Re: Excel to Fixed Format .txt (2002)
Steve
Can you point me to information about using a plus sign at the beginning of a formula as you have done (=+.......)
I've seen this used from time to time but don't understand it. Thanks

20031121, 08:18 #4
 Join Date
 Jan 2002
 Location
 Waukegan, Illinois
 Posts
 8
 Thanks
 0
 Thanked 0 Times in 0 Posts
Excel to Fixed Format .txt (2002)
Is there a way to have data in a workbook and save it in a .csv or .txt file format and have it end up having a given format?
For example cell D4 contains the word Part 1 Cell E4 contains the number 536.0 cell F4 contains the number 242.3 and cell G4 contains the number 11
This is then saved in a fixed format where each cell information would then be 10 digits / spaces long and the information from each cell would be separated by a / ?
For example it would then look like this<pre>/ / / / part 1/ 536.0/ 242.3/ 11/</pre>
(sorry, this forum takes out the spaces between the /'s but assume there is a combination of 10 digits and spaces between each /.)
The reason for doing this is we have a CNC controlled panel saw that will only take data in the format as I

20031121, 11:01 #5
 Join Date
 Mar 2002
 Posts
 84,353
 Thanks
 0
 Thanked 30 Times in 30 Posts
Re: Excel to Fixed Format .txt (2002)
Old habits die hard. In Lotus 123 (and VisiCalc before that), formulas didn't begin with =, but with + or  or @. You wrote +A1*B1 or E3+G2. Microsoft decided to start formulas with = in Excel, but wanted to make the transition for Lotus users as easy as possible. So you can still enter formulas the Lotus way; Excel will insert an = sign in front of them. You can even enter @SUM(A2..A5).

20031121, 11:04 #6
 Join Date
 Jul 2002
 Location
 Pittsburgh, Pennsylvania, USA
 Posts
 11,225
 Thanks
 14
 Thanked 342 Times in 335 Posts
Re: Excel to Fixed Format .txt (2002)
It is not necessary. In excel formulas and functions start with equal (=).
I sometimes start entering the numbers with plus or minus. Excel will keep these in if entered and just "tack on" the equal sign.
=A1 is equivalent to =+A1.
Steve

20031121, 11:06 #7
 Join Date
 Jul 2002
 Location
 Pittsburgh, Pennsylvania, USA
 Posts
 11,225
 Thanks
 14
 Thanked 342 Times in 335 Posts
Re: Excel to Fixed Format .txt (2002)
Yes and that is exactly where I picked up the habit. <img src=/S/grin.gif border=0 alt=grin width=15 height=15>
Steve