Sum values in formula CONCATENATE

  • I have a text stating concatenate with randombetween ( As in the example )


    I would like to sum the two numbers, without using "mid" or "left" or "right" formula, because randbetween can generate any 1,2, 3 or 4 digit numbers and using mid, right or left will give error.


    Is there any other way

  • Re: Sum values in formula CONCATENATE


    Try:


    [COLOR="#0000FF"]=TRIM(MID(SUBSTITUTE(D5," ",REPT(" ",100)),100,100))+TRIM(MID(SUBSTITUTE(D7," ",REPT(" ",100)),100,100))[/COLOR]

    Where there is a will there are many ways. Finding one that works for you is the challenge!

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!