remove all "+" from sheet

I need a code to add to my VBA that will remove all "+" from the entire sheet.
Euro5Asked:
Who is Participating?
 
Saurabh Singh TeotiaCommented:
You can just run the following code and it will remove + sign from all the cells values in your worksheet..

Sub Modifydata()
    Cells.Replace What:="+", Replacement:="", LookAt:=xlPart, SearchOrder:=xlByRows
End Sub

Open in new window


Saurabh...
0
 
gowflowCommented:
@Saurabh
Powerful !!! Am impressed.

gowflow
0
 
Saurabh Singh TeotiaCommented:
@Gowflow,

Thanks.. :-)

Saurabh...
0
 
Euro5Author Commented:
Thank you!! Excellent.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.