Posts by just_jon

    Would the below generate the desired result, given A1:D1 as the range of interest?


    Code
    =A1&IF(LEN(A1&B1)>LEN(B1),"/","")&B1&IF(LEN(B1&C1)>LEN(C1),"/","")&C1&IF(LEN(C1&D1)>LEN(C1),"/","")&D1


    It will show a semi-colon near the end of the formula; ignore it.