Results 1 to 2 of 2
  1. #1
    2 Star Lounger
    Join Date
    Sep 2001
    Location
    California
    Posts
    106
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I'm using Excel 2007. If I use Text to Column and set the delimiter to, say, a space; then later import a text file, Excel remembers the delimiter (the space) I previously selected in the Text to Column tool. Is there a setting someplace that's remembering this delimiter? It's creating extra work if I forget to remove/change the delimiter.

    Thanks for your help with this.
    Thanks,
    Caroline in lala-land

  2. #2
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts
    Nope - it's a 'feature' of Excel that is more often than not annoying. You have to remember to turn it off or do another TTC with no delimiters specified.
    Regards,
    Rory

    Microsoft MVP - Excel

Posting Permissions

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