Posted on January 26, 2020January 26, 2020 by kuekawaExcel string functions =CONCATENATE("Q",K12,"",C12) =LEFT(L12,32)