I would like to split easily a cell in two cells

  • Thread starter Thread starter Alain
  • Start date Start date
A

Alain

I search for the equivalent of end of paragraph in word processors.
Suppose that A1 contains a string, and that A2 is empty.
I would like to edit A1, put my text cursor somewhere, and by an eas
combination of keys, leave in A1 the left part of the string, and mov
in A2 the queue of the string.

before
/ A
1 head (I put my cursor here) tail
2 (empty)

after
/ A
1 head
2 tail

Is it possible with Excel, or VBA ?
Alai
 
Hi

Enter into place, where you want to split, some unused (in this cell)
character (like '_'). Leave the edit mode, and select from menu
Data.TextToColumns, and set delimiter to character you entered. Finish
 
Back
Top