Previous Topic Next Topic

Need a macros to be used in excel

Closed
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
Hello,
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 reply

Answer 1 / 1
Trowa
Jun 8, 2009 at 07:44 AM
Hi,

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.
0