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?
Bookmarks