I have a text string in a cell. it is comprised of a series of numbers and text. i would like to "cut" the first part of the string starting from the first space and paste in the cell to the left.
For example.
range("b11") has the following: "This is my example"
I would like to perform the following:
range ("A11") would equal "This"
Range ("b11") would equal "is my example"
(note the space has been completly removed as well)
Thanks in advance for any help.
(Also...the first word never has a set length)