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 ...
First, set up a model cell with the replacement formatting. Next, press Ctrl+H to launch the Find and Replace dialog. There, define both the Find What and Replace With formatting by clicking "Choose ...