I have an Excel sheet I am building to help calculate some stuff for an automated script that we use often

This is how I want it to work -

Column A
"name"

Column B
"address"

Column C
"Concatenate" (this is a list of characters to format the list from Column A correctly with spacing and commas and quotes)

Column D
"Concatenate" (this is a list of characters to format the list from Column B correctly with spacing and commas and quotes)

Column E
I want to have auto pasted the concatenated text from Column C show it is just showing the value (Paste Special - Values) instead of the formulas.

Column F
I want to have auto pasted the concatenated text from Column D show it is just showing the value (Paste Special - Values) instead of the formulas.

I cannot figure out how to tell Excel to paste these concatenated values so it is just showing the text values of the formula instead of the formula itself.

Is there a way to do this?