If your source column is not already formatted as text, you can first copy-paste it as text in a text editor (Notepad, MS Word...), then re-copy from the text editor and paste it in the destination text-formatted column.