+ Reply to Thread
Results 1 to 4 of 4

Saving spreadsheet as space delimited text file

  1. #1
    Registered User
    Join Date
    12-03-2012
    Location
    Wisconsin, United States
    MS-Off Ver
    Excel 2007
    Posts
    12

    Saving spreadsheet as space delimited text file

    Hello all,

    I have a large spreadsheet I need to save as a space delimited file. I need at least three spaces between each of the columns, although I would like to be able to set the amount of spaces. I have tried saving my worksheet as a .csv which would work with the program I am using except it creates a leading space before the first data in the first column.

    Here is a sample of the data I have:

    <01/01/2008 00:00:03><spacing><4.476><spacing><0.287>
    <01/01/2008 01:00:03> <spacing><7.393><spacing><0.033>

    I hope there is an easy solution to this. I have looked across the web but have been unable to find something that will work for my needs.

    Thanks in advance!

  2. #2
    Forum Expert Jakobshavn's Avatar
    Join Date
    08-17-2012
    Location
    Lakehurst, NJ, USA
    MS-Off Ver
    Excel 2007
    Posts
    1,970

    Re: Saving spreadsheet as space delimited text file

    Is a macro solution acceptable??
    Gary's Student

  3. #3
    Registered User
    Join Date
    12-03-2012
    Location
    Wisconsin, United States
    MS-Off Ver
    Excel 2007
    Posts
    12

    Re: Saving spreadsheet as space delimited text file

    Sorry for the delayed response! I don't really know macros all that well. However, I would be happy to try to learn if you feel it would be an effective solution.

    Thanks again!

  4. #4
    Forum Expert Jakobshavn's Avatar
    Join Date
    08-17-2012
    Location
    Lakehurst, NJ, USA
    MS-Off Ver
    Excel 2007
    Posts
    1,970

    Re: Saving spreadsheet as space delimited text file

    O.K.

    Here is a sample file. Just change the destination to meet your needs.
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1