Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: Data> Text to Columns - ARGH!

  1. #1
    New Member
    Join Date
    Feb 2002
    Location
    State? Insanity! :)
    Posts
    26
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default


    Help.. I have a pipe delimited ascii file I tried to import with no success, some of the data gets converted by excel. SO.. I have cut and pasted the entire document into a worksheet, I have highlighted ALL cells and formated them as "text" so that my data doesnt get converted and changed.
    As I do the "text to columns" Excel converts my data as if I hadn't formatted the cells at all.

    HELP!

    thanks!

  2. #2
    New Member
    Join Date
    Feb 2002
    Location
    State? Insanity! :)
    Posts
    26
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Woot!
    I figured it out.. all by my little lonesome!



    never noticed that little array of choices for output.. lol

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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