I would like to split easily a cell in two cells

From: Alain (Alain.12y8kt_at_excelforum-nospam.com)
Date: 03/11/04 

Date: Thu, 11 Mar 2004 04:23:19 -0600

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 easy
combination of keys, leave in A1 the left part of the string, and move
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 ?
Alain 

---
Message posted from http://www.ExcelForum.com/

Relevant Pages

  • Re: changing the world
    ... All lovely delighted preservations wherever answer as the head ... surveyors resign. ... The string other than the regional port is the ...
    (sci.polymers)
  • Re: Still in while loop hell, Now with refined question!
    ... Besides all the advice on how to get a line in to your program, you have a separate problem of how to do the loop, and how to stop it. ... public String retrieveLine() ... Now you need to have an addmethod in NodeWorker. ... This is where you use that one part of your original program where you manipulate head and prev. ...
    (comp.lang.java.programmer)
  • RE: Passing over Requery
    ... > The other stuff you said went over my head. ... >> Is stFCarton a string data type? ... >> Executemethod of the Database object to set options on the action query. ...
    (microsoft.public.access.formscoding)
  • Re: OT weed eaters
    ... A personal note I hate those bump string extender mechanisms. ... The head can be re-filled without taking the head ... Being a 4 stroke it doesn't smoke, there is no mixing of oil and gas ... I modified the blade head to accept skilsaw blades. ...
    (rec.crafts.metalworking)
  • Re: A challenge to non-SRians
    ... he would have been forced to admit it everytime he posts. ... > the funnybook physics labs when I was a grad student. ... > and managed to wind up the entire string around a pony tail on the ... > top of head. ...
    (sci.physics.relativity)