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 there a way to lock in the merged column that will allow me to paste in new location? Thanks!
2 Replies
In that case you should convert your formulas into Values before deleting the columns referenced in the formula. To do that follow these steps...
- Copy all your formula cells and press Ctrl+C to copy them.
- While all the cells are still selected, right click on any of the selected cells and click on paste icon with 123 over it. Refer to the image below.
- Or after copying the cells in the first step, press the key combination Alt, e, s, v and hit Enter.
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.
