Results 1 to 8 of 8
  1. #1
    2 Star Lounger
    Join Date
    Jan 2001
    Location
    Perth, Western Australia, Australia
    Posts
    190
    Thanks
    0
    Thanked 0 Times in 0 Posts

    How to insert tabs into a cell (2002, XP Pro)

    Hi all,

    Got the 'flu and the head is slow.
    I cannot remember - how do you enter a tab into a cell from the keyboard?

    I need thai as I am using Excel to store text strings for use in comparison testing for some automated testing software.
    The text I am comparing has embeded tabs, therefore the values in Excel will need to be the same.

    Thanks in advance.

  2. #2
    2 Star Lounger
    Join Date
    May 2005
    Location
    Vancouver, Br. Columbia
    Posts
    223
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: How to insert tabs into a cell (2002, XP Pro)

    Im not sure what you mean by tabs?
    sheet tabs?

  3. #3
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: How to insert tabs into a cell (2002, XP Pro)

    One way would be to use a formula like this:

    <pre>="ABC"&CHAR(9)&"DEF"
    </pre>

    Legare Coleman

  4. #4
    2 Star Lounger
    Join Date
    Jan 2001
    Location
    Perth, Western Australia, Australia
    Posts
    190
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: How to insert tabs into a cell (2002, XP Pro)

    Patrick,

    Tabs - the fat key on the side of the keyboard, Character 10, Ctrl-J on the old teletype keyboards.
    I know I have entered them previously in excel, I just cannot remember the key combination.

    Thanks

  5. #5
    2 Star Lounger
    Join Date
    Jan 2001
    Location
    Perth, Western Australia, Australia
    Posts
    190
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: How to insert tabs into a cell (2002, XP Pro)

    Legare,

    Thsi will be a problem for a lot of users who are unfamiliar with the help screens in excel, let alone small formula's like that.
    I was hoping someone could remember the key combination to enter the tab character directly. Similar to how Alt-Enter in a cell inserts a newline.


    Thanks

  6. #6
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: How to insert tabs into a cell (2002, XP Pro)

    As far as I know, there is no way to enter the Tab character in an Excel cell directly.

  7. #7
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: How to insert tabs into a cell (2002, XP Pro)

    One thing that is not mentioned yet is the indents feature. I know it is not tabs as such, but you can use it in a cell to align data off the margin of the cell.
    Regards,
    Rudi

  8. #8
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: How to insert tabs into a cell (2002, XP Pro)

    You could also use the VBA procedure below, which could be assigned to a button on the tool bar. However, the cell can't be in Edit mode to executed the macro. Any text in the cell would have to be entered, the cell reselected, and then the macro executed.

    <pre>Public Sub InsertTab()
    ActiveCell.Value = ActiveCell.Value & Chr(9)
    End Sub
    </pre>

    Legare Coleman

Posting Permissions

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