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
 
Great Arvi,
I think I will do a VBA macro from your suggestion.
Thanks a lot,
Alai
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

display content of merged cells 1
Combining Text From Cells 3
Give blank in cell 2
Split Cell Range into Multiple Cells 1
splitting numbers 3
b;ank cells in calculations 2
Excel Need Countifs Formula Help 0
Addition function of multiple cells 10

Back
Top