E=mc2
asked on
Excel Macro to delete specific characters
I need an excel Macro to delete specific characters, namely " and ,
When it finds any quotes or commas it needs to delete these.
When it finds any quotes or commas it needs to delete these.
ASKER
Column A and Column B only, approximately 6000 lines.
try this code
gowflow
Sub DelChar()
Dim WS As Worksheet
Dim cCell As Range
Dim sTemp As String
Set WS = ActiveSheet
For Each cCell In WS.UsedRange.SpecialCells(xlCellTypeConstants)
sTemp = cCell.Value
sTemp = Replace(sTemp, ",", "")
sTemp = Replace(sTemp, """", "")
cCell.Value = sTemp
Next cCell
End Sub
gowflow
ASKER
Thanks. For some reason this is affecting the data in Column A in a manner that it is not desired.
What if I only wanted to apply these commands to Column B only??
What if I only wanted to apply these commands to Column B only??
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
gowflow