Using FindAll to Replace

[mrjojo]

Here is the Problem. I need to be able to use the FindAll function to search the entire workbook for these characters: ~ ` ^ ‘ | \ / : ; “ * # @ and also a double decimal ".."

Once found, I need it to replace them with nothing, just delete it, except for the \ and /, which I need them replaced with spaces. The double decimal needs to be changed to just one decimal "."

Any help would be appreciated.

 

[zaska]

sorry for posting in wrong thread

 

[Barbara Excel]

I have done this recently,I just left the replace as blank, this worked well.
I also used the space for those to be replaced with spaces- no problem either.
I did however do the individual characters one at a time, but took no time at all using the standard find all and replace all

hope that helps

Barbara Excel

 

[Scott Huish]

Why do you need FindAll?

Sub test()
Dim t, r, ws As Worksheet
t = Array("~", "`", "^", "‘", "|", "\", "/", ":", ";", "“", "*", "#", "@", """", "'", "..")
For Each ws In Worksheets
    For Each r In t
        ws.Cells.Replace "~" & r, ""
    Next r
Next ws
End Sub

 

[mrjojo]

Thank you so much, this worked great.