macro to get rid of part of formula

[daveyc3000]

hello, in certain 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?

 

[Luke M]

Hi Davey,

I just answered your post over here:
http://www.ozgrid.com/forum/showthread.php?t=195287

 

[daveyc3000]

sorry about the cross post

i asked my acquiantance and he suggested

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

seems to work...hope there's no volatility

 

[NoSparks]

That's quite the acquaintance you have there...
http://www.mrexcel.com/forum/excel-questions/862089-getting-rid-part-formula-using-macro.html

 

[chirayu]

I also got bored & came up with something. Not as high tech but does the job.

Code in the file is

Sub FormulaSplitter()

Dim MyFormula As String
Dim FormulaPartA As String
Dim FormulaPartB As String

MyFormula = Range("F2").Formula

FormulaPartA = Left(MyFormula, 14)
FormulaPartB = "=" & Right(MyFormula, 5)

'Obviously you could also use MID for splitting

Range("G2").Formula = FormulaPartA
Range("H2").Formula = FormulaPartB

End Sub