Combine data from 2 columns into 1 column (2024)

I took the following steps and had the following problem.

Steps:

1. In the 1st Excel document, data in the first two columns was combined.

2. The combined data was entered into the third column.

3. The data in the third column was highlighted and copied.

4. The data in the third column of the 1st Excel document was copied and pasted into the first column of the 2nd Excel document.

Problem:

The data did not paste. Instead, the first column of the 2nd Excel document showed "REF" throughout.

Question:

How can I pasted the data into the 2nd document without getting "REF" instead?

Thanks,

Ben

[Admin removed phone number for privacy reasons]

[Admin removed email address removed for privacy reasons]