Keeping the Data, losing the formula (concatenate)

I've used the concatenate to merge line one and two, an address. How do I elsewhere preserve the new address as a result, while getting rid of the linked data. My preference is to do it as a new file so there are no constraints regarding working within one .xls. Thank you for your help.

how about this: highlight the info, right click, copy, click in your detination cell, right click, paste special, values

That was simple. Thank you, Thank you, Thank you.

glad to help