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!
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.