Question: how to copy text from one cell to another?
Answer: Select the range you want to copy as text value only, and press Ctrl + C. Click to select a blank cell for placing the copied cells. Then click Home > Paste > Values. See screenshot: