many delet and replace

		Microsoft Office Forums > Microsoft Excel > Excel
many delet and replace

FAQ

Thread Tools

Display Modes

06-14-2017, 05:00 PM

NoSparks

Windows 7 64bit many delet and replace

Office 2010 64bit

Excel Hobbyist

Join Date: Nov 2013

Location: British Columbia, Canada

Posts: 842

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

« Previous Thread | Next Thread »

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

Other Forums: Access Forums

All times are GMT -7. The time now is 01:32 PM.