Delete text?

Question

How do I delete text?   I am in Microsoft Excel for Mac, v. 16.34 (20020900.)   I copied some text from a Word document into an Excel spreadsheet.   I wanted to copy and paste that text into the desired cells of the spreadsheet, but Excel won't let me do anything with the pasted text.  I cannot copy it.  I cannot cut it.  I cannot paste it where I want it.  I have tried deleting the column(s) in which the text appears.  I have tried selecting all the text and deleting.   I get no response.  Excel keeps the text where I do not want it and refuses to let me move or delete it.   How do I get rid of this now unwanted text?

Answer 1

No, I just hit "command p" as I always do.

Answer 2

I tried each of the three special options in Edit>Paste Special.   Each of the options inserts the current content of the Clipboard into the selected cell.   That text covers over the unwanted text in that cell.   One of the options--I did not notice which--also moved the cells down one row.   When I then deleted the new text inserted from the Clipboard, the original, unwanted text remained in the spreadsheet.   Deleting what I had special-pasted did not move the text below back up into the newly vacated cell.  So I am still left with the original text that I cannot delete.

Answer 3

Try Edit > Paste special options and see if the result is as desired.

Answer 4

Or, make that "command v."   I have been using Word for so long that my fingers remember the keystrokes even if the rest of me does not.

Answer 5

Was the copied text in a special format such as within an Table in Word?

DId you use Edit > Paste Special to paste the text in Excel? If yes, which option did you choose?