Know how to create concatenate results. Have forgotten how to change the results into numbers or text, instead of showing the formula.
Have text in 3 different columns. Have figured out how to combine all 3 into one column. However, when I click on a cell, all that I see is the concatenate formula. Would like to have the results in the actual combined text.