Sep 19 2019 11:52 AM
I am merging text from two columns. The merge was successful, but I want to use only the merged text and delete the other two columns. I get #REF errors because the original text was removed. Is there a way to lock in the merged column that will allow me to paste in new location? Thanks!
Sep 19 2019 12:08 PM
Hello @kmartin500,
If you highlight the merged column you can press Ctrl+C, then Ctrl+V, then Ctrl, then V. This will paste the references as values. After doing this, when you delete the original two columns you should not receive a #REF error.
Sep 19 2019 12:13 PM
In that case you should convert your formulas into Values before deleting the columns referenced in the formula. To do that follow these steps...