Removing " as a Special Character

[GreatOffender]

I have a sheet with formulas in it and I need to remove them which isn't a problem except one of the cells is creating a problem. I cannot adjust the source data or I would fix it there first. Each cell in the first 3 columns is in a formula format similar to ="xxxx-xx-xxxx" and the formulas are not visible unless you select the cell. But, there is one cell with an error in which the "=" is visible (not part of a formula). The unselected/highlighted cell clearly shows the "=". When I try and remove the formulas using a ranged.value it errors because of that one visible "=". If I try and remove that special character I am left with a sheet surrounded by quotation marks and I haven't figured out how to remove quotation marks without the code believing I am trying to surround it with quotes. Making sense?
I seem to be boxed in??? No, I cannot attach a sample because I need to alter it for opsec reasons. Once I alter it I cannot reproduce it.

 

[MARK858]

I take it that you have tried a Find/Replace with = in the Find box (or possibly ~=) and leaving the Replace box blank?

 

[GreatOffender]

I've tried using

Cells.Replace What:="=", Replacement:="", LookAt:=xlPart

but it removes all of the "=" and now I am left with 3 columns surrounded by quotation marks. I would remove the quotation marks using VBA but I am not skilled enough because just placing a " in a line causes the system to start looking for the closing ". How does one remove all of the quotation marks by using VBA?

 

[jolivanes]

Either one should remove double quotations

Sub Maybe_A()
    ActiveSheet.UsedRange.Replace What:="""", Replacement:="", LookAt:=xlPart
End Sub

Sub Maybe_B()
    ActiveSheet.UsedRange.Replace What:=Chr(34), Replacement:="", LookAt:=xlPart
End Sub

 

[GreatOffender]

jolivanes - Thanks! I see the err of my ways. When I tried to remove the quotes with that bit of code I wasn't putting the double "" in between the outer quotes. I was just using one and this caused an obvious error. Perfect storm of speed, aggravation, and just plain stupidity.

 

[jolivanes]

As long as you get it to work
Good Luck