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: