I have created a macro in excel. I edit (F2), delete some unwanted text, and press enter. What happens is the entire contents of the first (original) cell is "copied" to any other cell in which I execute the macro. QUESTION: How can I simply delete some unwanted text in every cell (the contents are uniformed) and NOT have the contents of the original cell copied into each of the other cells on which I run the macro? Please note that I am a VBA Newbie. I have searched through "Help" and cannot find or figure this out. You help is much appreciated. Regards, Kevin.

It sounds like you've "recorded" a macro? When you do this, if you enter some text into a cell, then the macro records the text that you ended up entering. It does not work out how you adjusted it. Thus if you rerun the macro, it will enter the same text that you originally entered. If you record yourself doing a find/replace then that may solve it. Otherwise, you're going to need to spell out the problem a bit more specifically, and I (or someone) will give you a piece of code to do exactly what you want. (ie Is it always the same text you want to remove) Hope thats of help Tom