|
|
|
|
#1
06-11-2017, 05:34 PM
|
|||
|
|||
many delet and replace
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 ... 
|
|
#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
__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
|
|
#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
|
|
|
|
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 |
Windows 7 64bit 
Office 2010 64bit
Hybrid Mode