View original (French)

Tabulation in a cell in InDesign or Excel

Solved
coluches -  
 coluches -
Hello,

I would like to know if it is possible to jump to the next cell in the middle of a text field.
Or do I have to use Ctrl X Ctrl V each time?
Thank you
Configuration: Windows XP Firefox 2.0.0.14

4 answers

  1.
    m@rina Posted messages 27560 Registration date   Status Moderator Last intervention   11 562
     
    Hello again,

    It's clearer now, indeed.

    For Excel, you'll need a macro like this:

    Selection.TextToColumns DataType:=xlDelimited, ConsecutiveDelimiter:=True, Space:=True

    If you want it to happen as soon as you paste something, you need to put the code in the relevant sheet:

    Private Sub Worksheet_SelectionChange(ByVal Target As Range)
    Selection.TextToColumns DataType:=xlDelimited, ConsecutiveDelimiter:=True, Space:=True
    End Sub

    But be careful, as soon as you paste text into a cell, that text will be split into as many cells as there are words separated by a space.
    Test it first.

    m@rina
    2
    1. coluches
       
      First of all, thank you for your response
      but I don't know much about Excel
      where should I put:
      Private Sub Worksheet_SelectionChange(ByVal Target As Range)
      Selection.TextToColumns DataType:=xlDelimited, ConsecutiveDelimiter:=True, Space:=True
      ?
      thank you
      0
  2. m@rina Posted messages 27560 Registration date   Status Moderator Last intervention   11 562
     
    You right-click on the sheet tab, and you choose "View Code".
    You just need to paste the code (don't forget the "End Sub") and test it.

    m@rina
    1
    1. coluches
       
      Thank you, it works! Is there a way to tell him to do it for tabulations instead of spaces?
      0
  3. m@rina Posted messages 27560 Registration date   Status Moderator Last intervention   11 562
     
    Hello,

    I didn’t understand your question…
    And besides, Excel and Indesign aren’t really the same thing…

    Can you explain again?

    m@rina
    0
    1. coluches
       
      Thank you, let me explain:
      I know that Excel and InDesign are not the same thing, but I have the same issue for both...
      When you create a table, normally you press the tab key to move to the next cell...
      I would like that after pasting a text field, each word (or several) would move it to the next cell, basically making a tab within the text that would place the text into the next cell.
      For example: I have aaaa aaaa bbbb bbbb bbb and I would like to put the characters b in a new cell.
      I hope it's clearer now :)
      0
  4. coluches
     

    Private Sub Worksheet_SelectionChange(ByVal Target As Range)
    Selection.TextToColumns DataType:=xlDelimited, ConsecutiveDelimiter:=True, Tab:=True
    End Sub

    It works great!!!! Hours of work saved!
    Thank you!
    0