I am quite new to Excel Macros; I am used to using Word Macros to manipulate tables, and it seems Excel is quite different.
I am trying to 'cut' the last part of the text in a cell and paste it into the adjacent cell, but cannot find much help on this anywhere. It seems to be a fairly basic operation, but without knowing syntax and methods, I am at a loss.
I want to repeat this task for a long range of rows.
For instance, a cell has the value "05/09/08 590.25" and I want to move the "590.25" to the cell to the right, and preferably delete the two spaces (" ").
Thanks a ton for your help!
-N
I am trying to 'cut' the last part of the text in a cell and paste it into the adjacent cell, but cannot find much help on this anywhere. It seems to be a fairly basic operation, but without knowing syntax and methods, I am at a loss.
I want to repeat this task for a long range of rows.
For instance, a cell has the value "05/09/08 590.25" and I want to move the "590.25" to the cell to the right, and preferably delete the two spaces (" ").
Thanks a ton for your help!
-N