I am attempting to learn recording macros.
I would like to click on any cell and execute a macro that does the following keystroke
F2, HOME, delete, delete, delete
This will remove unwanted characters from the beginning of the contents of the cell.
The instructions in excel's help file do not help me.
At what point do I start recording?
Do I need to be in a cell the macro will be used on to start the recording?
Do I move to the next cell before stop recording
In previous attempts it seems to copy the contents of the cell that was used during the recording.
I am sure this is an elementary topic that someone can help with.
Thanks,
Gary
I would like to click on any cell and execute a macro that does the following keystroke
F2, HOME, delete, delete, delete
This will remove unwanted characters from the beginning of the contents of the cell.
The instructions in excel's help file do not help me.
At what point do I start recording?
Do I need to be in a cell the macro will be used on to start the recording?
Do I move to the next cell before stop recording
In previous attempts it seems to copy the contents of the cell that was used during the recording.
I am sure this is an elementary topic that someone can help with.
Thanks,
Gary