Simple VBA: Delete data in bracket

[uglyphoto]

VBA: In all excel book sheets, delete data in the bracket after the period character that appears without gaps.
For example: ".(5,6)" will become "."
For example: ".(4,3,7,10)" will become "."

 

[Phuoc]

Try:

Sub Macro1()
    Cells.Replace What:=".(*)", Replacement:=".", LookAt:=xlPart
End Sub

 

[uglyphoto]

Thanks Phuoc.