Need a macros to be used in excel

humphry Posts 1 Registration date Wednesday June 3, 2009 Status Member Last seen June 4, 2009 - Jun 4, 2009 at 12:41 AM
 Trowa - Jun 8, 2009 at 07:44 AM
I want a vbscript for a macros to be used in excel which would do the following operastion:

It will find the characters/delimeters in the excel and replace it by another character/delimeter.

Please send me a vbscript for this purpose.
Also tell me how to run the macros

1 response


Try this, record a macro. Press: Ctrl + H and type what you want to change and what you want to change it into and click OK. Stop recording and look at the VBA code using Alt + F11.

Hope this helps,
Best regards.