Adding a space within a cells value
I am trying to input a space within a cell, and then copy the task all
the way down the column for all the cells in that column. So each
cells value will change as follows.
G8599999
G7944444
G8155555
becomes
G85 99999
G79 44444
G81 55555
Is there a Macro I can use to accomplish this. I have tried to have
the Macro recorder record it however it just replaces each cell with
the same value that I recorded. I have also found some other
explanations of such a macro, however I could not understand them, so
any basic explanation of the code would be much appreciated. Thank you
very much for any help that can be provided.
-Keith
|