Delete certain text in a cell while keeping the rest

[ericj]

Excel 2003

Have a monthly reported generated with varying number of columns and rows.

Want to delete specific data in a cell that is surrounded with { }, then move on to the next cell to check for { } and delete that data until you reach the last column and row with data in it.

For Example if cell C10 contained: Hello this is John {I want to delete only this data}
Or cell E4 contained: 5607 East 68th St {Chicago}.

Delete the {Chicago} and keep the address.

If this is possible, can you please supply VBA code.

Thank you
Eric

 

[AlphaFrog]

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

 

[ericj]

Thank you so much. Worked perfectly.
Eric