Results 1 to 7 of 7
  1. #1
    WS Lounge VIP sdckapr's Avatar
    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 paste-special -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

  2. #2
    New Lounger
    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

  3. #3
    3 Star Lounger
    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

  4. #4
    New Lounger
    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

  5. #5
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Excel to Fixed Format .txt (2002)

    Old habits die hard. In Lotus 1-2-3 (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).

  6. #6
    WS Lounge VIP sdckapr's Avatar
    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

  7. #7
    WS Lounge VIP sdckapr's Avatar
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •