Just Want to Break a Long Formula into 2 parts, in Excel VBA

Job ID: 34779135

Budget: $10 – $30 CAD

I am not a pro in VBA but have my own project, for which I am facing this issue, that when I am adding a lengthy formula in VBA excel it cant take it and I have to break the formula into 2 parts, but when I am breaking the formula into 2 parts using "Space"&"_", its giving syntax error, Missing End Bracket.