Forum Discussion
Merge Text from two columns
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 ther...
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.