A macro can be done, but it might be safer to enter the following in a blank row 1 cell of an adjacent column to the right (or a newly created blank column) the following: assuming the original data are in column A:
Then autofill column B by doubled clicking on the small dark square at the bottom right of cell B1 when it is selected. This should autofill column B to the end of Column A entries (assuming they are contiguous) and also leave the column B cells selected. Copy the column B cells and the do a PASTE SPECIAL > VALUES (either in place in column B or over the top of the original data in column A. This should create a new dataset that is minus the first two characters.
If you still need or want a macro to do this, see the attached. But be warned that the macro will do exactly what you ask -- remove the first two characters from each cell in column A. If you run it a second time, the next two characters will be gone, too. If someone runs it "for" you a week later, an additional two characters will disappear.
Having a macro around that can do inadvertant harm always bothers me.
Please help Oz share knowledge among all users by posting your questions in a public forum rather than using a Private Message.
There are currently 1 users browsing this thread. (0 members and 1 guests)