Suppose we have a workbook with employee data (employee names) of an organization, as shown in the above image. Column A contains the first names of the employees, column B contains middle names of ...

If I enter the following:<BR><BR>=CONCATENATE("Design Avg. Flow per Cell = ",J12," g.p.d. / ",J21," Cells")<BR><BR>where J12=6300 and J21=3, I get<BR><BR>Design Avg. Flow per Cell = 6300 g.p.d. / 3 ...