I am trying to copy the text from a cell that I used the Concatenated function in but it only copies the formula (=CONCATENATE(A2,C2,D2,E2,F2,G2,H2,I2,J2,K2) ),not the actual text that I want.

How can I copy just the text and paste it somewhere else?

Thanks!