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 réponses

Réponse 1 / 4
m@rina Posted messages 27323 Registration date   Status Modérateur Last intervention   11 546
 
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
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
Réponse 2 / 4
m@rina Posted messages 27323 Registration date   Status Modérateur Last intervention   11 546
 
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
coluches
 
Thank you, it works! Is there a way to tell him to do it for tabulations instead of spaces?
0
Réponse 3 / 4
m@rina Posted messages 27323 Registration date   Status Modérateur Last intervention   11 546
 
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
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
Réponse 4 / 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