Results 1 to 7 of 7
  1. #1
    Platinum Lounger
    Join Date
    Nov 2001
    Location
    Melbourne, Victoria, Australia
    Posts
    5,016
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Alt + numeric data entry (2000)-MULTI-Alt + numeric data e

    I recall somebody mentioning how to enter the linebreak char(10) character into a cell by using the Alt key with a number pad combination. I've tried this, but can't seem to find it. I know that Alt + Enter will generate one, but could somebody give me the equivalent for the number key pad please ?

    thanks

    Alan

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

    Re: Alt + numeric data entry (2000)-MULTI-Alt + numeric data e

    Messing about in XL97, I'm unable to get any character below Dec 20 into a cell using the Alt-NumericKeypad method. I know it can be done in other parts of Excel, for example we can enter Alt-10 via Number Keypad into the Text-to-Columns, Delimited, Other, character box.
    -John ... I float in liquid gardens
    UTC -7ąDS

  3. #3
    3 Star Lounger
    Join Date
    May 2002
    Location
    Mpls, Minnesota, USA
    Posts
    271
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Alt + numeric data entry (2000)-MULTI-Alt + numeric data e

    AlanMiler,
    Could it be pressing Alt - Enter you are looking for?
    If the cell is formatted to wrap text and you type text in the cell, you can force it to line feed by pressing holding down the Alt key while pressing the Enter key.

    Chuck
    Chuck Reimer
    I'm from the Government and I'm here to help...

  4. #4
    Platinum Lounger
    Join Date
    Nov 2001
    Location
    Melbourne, Victoria, Australia
    Posts
    5,016
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Alt + numeric data entry (2000)-MULTI-Alt +

    Thanks John. I found the same limitation. Perhaps the message I'd seen related to the other dialog types you mentioned. Anyway, it's apparently just just Alt + 10 in those cases.

    Interestingly, I found that the Alt + Enter can be treated as an ordinary character for formulas within cells. For instance, it works inside the quotes for a formula like:
    SEARCH("
    ",C2)
    if entered directly into the cell formula as Alt+Enter. I had been using
    SEARCH(CHAR(10),C2)
    before I discovered this.

    Alan

  5. #5
    Platinum Lounger
    Join Date
    Nov 2001
    Location
    Melbourne, Victoria, Australia
    Posts
    5,016
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Alt + numeric data entry (2000)-MULTI-Alt + numeric data e

    Thanks Chuck, but this is not what I was after. As per my original post, I knew that Alt + Enter would produce a linebreak. I was after an Alt + numeric keypad combination.

    Alan

  6. #6
    3 Star Lounger
    Join Date
    May 2002
    Location
    Mpls, Minnesota, USA
    Posts
    271
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Alt + numeric data entry (2000)-MULTI-Alt + numeric data e

    Alan,
    I reread your post. Sorry - you were quite explicit and I just missed it! <img src=/S/flee.gif border=0 alt=flee width=25 height=25>
    Good luck finding the answer you need.
    Chuck
    Chuck Reimer
    I'm from the Government and I'm here to help...

  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: Alt + numeric data entry (2000)-MULTI-Alt +

    FWIW, in XP I discovered that you can enter Alt-011 and up.
    -John ... I float in liquid gardens
    UTC -7ąDS

Posting Permissions

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