CONCAT is replacing the CONCATENATE function, which is gradually being phased out. With CONCATENATE, you couldn't work with arrays (for example, A1:A40), only individual cell references (for ...