macro to delete one character in a cell

I'm trying to use Excel 2003 macros for the first time and am very frustrated by it's recorder function. I've used several standalone TSR macro recorders several years ago and they were much easier but certainly not as feature rich.

I have a spreadsheet that I've been using for a couple of years where I have manually entered data. My company has recently started to dump data into an Excel sheet but instead of pure numeric or date values being used they are extracting the values with the ' character starting the value. I want to strip this ' character.

What I do is select the cell I want to edit and invoke the macro. Then press {F2} to edit the contents of the cell, {Home} to move to the left, {Del} to delete the first character - the apostrophe, and {Enter} to complete the edit and move down one cell.

Using the recorder captures the following. Unfortunately it doesn't simply delete the first character, it copies the value of the previous cell to the next cell when I invoke the macro again.

Please Login or Register  to view this content.

It has to be easier than this, right?

.

OK, this month's report is in.

I edited the macro, removing the old code and inserting your suggestion. It deletes the first two characters.

I start with.... '14182

I want........... 14182

I'm getting..... 4182

?

Originally Posted by VBA Noob

Please Login or Register  to view this content.

removes first character from selection

VBA Noob

If I change the 2 to a 1 it will remove the ' . Also, I tested this for your original and my edit as below, it does not go to the next cell below as I wanted as if using the {Enter} key to complete the edit.

Please Login or Register  to view this content.

?

LOL we're cross posting.

The "Next cell" variable is not working.

Maybe "NextCell"

??

OMG! The "Selected" Range!!!! doh doh doh

That is brilliant!! What a time saver.

Thanks a million.