Microsoft 365 and Office | Excel | For business | Other
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
Copy it, right click in new sheet - Paste Special - Values
TEXTJOIN
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Anonymous
I have figured out how to join the text from columns A, B & C into column D, but after that if I want to copy and past the new column (D) to a different sheet, all that pastes is the #REF. How do I paste the actual new text?
Microsoft 365 and Office | Excel | For business | Other
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
Answer accepted by question author
Answer accepted by question author
Anonymous
I figured that out 2 seconds after I posted the question! LOL! Thankyou for your reply. :)