Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
merging 2 cells and adding a space. | Excel Discussion (Misc queries) | |||
Adding more space in a pulldown box? | Excel Discussion (Misc queries) | |||
Adding a space | Excel Worksheet Functions | |||
Adding a space? | Excel Programming | |||
Adding a space with =A59&B59 | Excel Worksheet Functions |