Results 1 to 8 of 8
  1. #1
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    Virginia, USA
    Posts
    1,560
    Thanks
    37
    Thanked 1 Time in 1 Post

    'Help' listing for parse (XP and 2000)

    Last night I was working on a personal project and needed to "parse" some data out of one column into two or three columns. You know: You have a list of names like "John Q. Public" in Column A, and you want to separate those three bits of information into three separate columns.

    I couldn't recall exactly how to do this, so I pressed F1 and keyed in "parse" in the search window. To my surprise, the word parse does not seem to exist in Help. So what we call "parsing" must go by some other name in the Microsoft world. Can someone tell me what secret words to use to find this topic in Help?

  2. #2
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Dublin, Ireland, Republic of
    Posts
    2,697
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: 'Help' listing for parse (XP and 2000)

    There is a Text to Columns wizard that will assist. Select the Column to be parsed and from the Data Menu select Text to Columns to launch the wizard. Select "Delimited" as the data type and on the next dialog select Space as the delimiter. That should parse out "John Q. Public" to 3 columns.

    Andrew C

  3. #3
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: 'Help' listing for parse (XP and 2000)

    Word "parse" appears in '02 help file, and leads to "Data, Text To Columns", which may be what you want. You will also find specific threads on separating out names elsewhere in the Excel Forum, for instance <post#=118094>post 118094</post#>.
    -John ... I float in liquid gardens
    UTC -7ąDS

  4. #4
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    Virginia, USA
    Posts
    1,560
    Thanks
    37
    Thanked 1 Time in 1 Post

    Re: 'Help' listing for parse (XP and 2000)

    Andrew: Thanks a bunch!

  5. #5
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    Virginia, USA
    Posts
    1,560
    Thanks
    37
    Thanked 1 Time in 1 Post

    Re: 'Help' listing for parse (XP and 2000)

    John: Thanks for the referral to another post--now I see there's more than one way to do this.

    You say "parse" shows up in your '02 Help file, but I'll be darned if I can find in my copy. I used the "'Index' tab / 1. Type keywords" and keyed in p-a-r-s-e...the list goes from parenthesis to password. Maybe I'm looking in the wrong place...? It's a moot issue now, of course--you guys have answered my underlying question anyhow. Thanks a heap!

  6. #6
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: 'Help' listing for parse (XP and 2000)

    Parse appears in XL2000 Help as well. I just typed it into the search field on the index tab.
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  7. #7
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: 'Help' listing for parse (XP and 2000)

    Hey Lucas, this is just an FYI, I'm not showing you this to be argumentative. And, while the word 'parse' shows, it doesn't lead
    -directly- to a help topic, so I can see why you would not have noticed.
    Attached Images Attached Images
    -John ... I float in liquid gardens
    UTC -7ąDS

  8. #8
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    Virginia, USA
    Posts
    1,560
    Thanks
    37
    Thanked 1 Time in 1 Post

    Re: 'Help' listing for parse (XP and 2000)

    Hi, John, and thanks for your reply. I've looked at this again, and you are correct, sir: "Parse" does show up in the list in Excel 2000. However, I just went to our one machine that uses Access XP, and the word in question ain't there!

    Like you said, I don't want to start nothin'. The big question's been answered anyway. But it is curious that this one word is missing in action on our machine.... Weird.

Posting Permissions

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