PHP Code:
 
Option Explicit
Sub RemoveSquareBrackets
()
Dim c As Range
Application
.ScreenUpdating False
For Each c In Range("G1"Range("G" Rows.Count).End(xlUp))
If 
Left(c1) = "-" Then c Mid(c2Len(c) - 1)
If 
Right(c1) = "-" Then c Left(cLen(c) - 1)
Next c
Application
.ScreenUpdating True
End Sub 
THank you .