Data> Text to Columns - ARGH!
Find bottlenecks in your Excel workbooks
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

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
  •  

 

 
DMCA.com