many delet and replace

bnyamin · #1 06-11-2017, 05:34 PM

hello
i need two vb code ...
1- delete many character
for example delete "a" and "&" and "{" and ...
2- replace many character

for example "{" with ")" and "d" with "3" and ...

Pecoflyer · #2 06-12-2017, 04:13 AM

Hi
this topic is well addressed.
Before posting it's always advisable to search the Net. Many answers are available

bnyamin · #3 06-14-2017, 01:58 PM

thanks
i cannot understand English good !!
because this is , i can't understand any question and solution
please answer !!

NoSparks · #4 06-14-2017, 05:00 PM

Experiment with this.

Code:

Sub DeleteOrReplaceCharacters()

With Range("A2:A10")
    .Replace "a", "", xlPart
    .Replace "&", "", xlPart
    .Replace "{", "(", xlPart
    .Replace "d", "3", xlPart
End With

End Sub

bnyamin · #5 06-17-2017, 08:22 AM

Thank you for sharing your wisdom with me.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
In Find and Replace, can Word stop after each Replace?	wardw	Word	1	06-08-2017 02:47 PM
VBA Batch Find & Replace for all MSOffice extensions, to replace File Name and Content of the File	QA_Compliance_Advisor	Word VBA	11	09-11-2014 11:51 PM
How to make replace - well - REPLACE	lawrencehare	Word	3	12-11-2012 12:00 AM
Help with find and replace or query and replace	shabbaranks	Excel	4	03-19-2011 08:38 AM
Replace	nsamraf	Word	0	03-25-2009 02:54 AM