getting rid of a part of formula using macro

[daveyc18]

on certian cells, the formula is =sum(x1,x2,x3)+x4+x5

is there any way to make a macro get rid of anything AFTER the sum...ie x4 and x5?

 

[mikerickson]

Perhaps

With Selection
    .Formula = Split(.Formula, ")")(0) &")"
End With

 

[daveyc18]

worked like a charm, thank you!