Hi Everyone -

I am currently using the concatenate function to join a sequence of text, using the following formula

=CONCATENATE(A1&"-"&B1"-"&C1)

What I then want is to be able to copy and paste the resulting answer, which is a code like this- MRC-GA-UK

I don't want to copy and paste the formula, or for the copy and pasted value to alter in the excel sheet in which I have copied it, I just want the text of the code - I am certain there is a simple way to do this, and am certain that my inability to find an answer is a result of my poor phrasing of the question - If anyone has any ideas - please let me know !

Thanks