Excel: Student sentence constructor - ad libs style - concatenate
Using concatenate to construct a sentence for grade schoolers.
Here is the main code:
=CONCATENATE(B3," is ",B4, " years old. ", B3," went to the ",B5," and saw a ",B6,".")
Here is the code that hides the sentence until it is ready:
=IF(ISBLANK(B6),"",CONCATENATE(B3," is ",B4," years old. ",B3," went to the ",B5," and saw a ",B6,"."))
Here's a copy: https://docs.google.com/spreadsheets/...