Using this code to get rid of extra character but then need to multiply by 1 to calculate dates correctly...I'm still actively working it...
Public Sub Remove()
Dim oCell As Range
Range("B8:BU172").Select
For Each oCell In Selection
oCell.Value = Application.WorksheetFunction.Clean(oCell.Value)
oCell.NumberFormat = "yyyy mmm dd"
Next oCell
End Sub
Public Sub Remove()
Dim oCell As Range
Range("B8:BU172").Select
For Each oCell In Selection
oCell.Value = Application.WorksheetFunction.Clean(oCell.Value)
oCell.NumberFormat = "yyyy mmm dd"
Next oCell
End Sub