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 ...
The concatenate function may not be as well known as other common Excel features such as IF and VLOOKUP, but it’s still effective, even though it performs a more simple function in nature. If you are ...
We can use two functions to add a prefix to multiple (or all) entries across a column. The first one is using the & operator, and the second is using the CONCATENATE function. Eg. We are creating the ...
Some results have been hidden because they may be inaccessible to you
Show inaccessible results
Feedback