0

When I paste some text from a browser into the Excel cell, it will copy the HTML format - colors, font type, sizes, into the cell as well. Is it possible to only copy&paste the plain text into the Excel cell?

Zhenyu
  • 275
  • 3
  • 5
  • 12

1 Answers1

1

You need to paste and match destination formatting

enter image description here

cybernetic.nomad
  • 5,415
  • 12
  • 25
  • Thanks, it works. Can I make this "Paste as destination format" as default, so I can just use CTRL V to paste instead of right click on the cell every time? – Zhenyu Aug 03 '18 at 20:45
  • It's OK, I found this thread https://superuser.com/questions/683258/excel-copy-paste-always-match-destination-formatting – Zhenyu Aug 03 '18 at 21:00
  • Is the screenshot from Excel2016? – Albin Aug 03 '18 at 22:15
  • **Try One Note**, Image to text , OCR: https://support.microsoft.com/en-us/office/copy-text-from-pictures-and-file-printouts-using-ocr-in-onenote-93a70a2f-ebcd-42dc-9f0b-19b09fd775b4 – Shaiju T Mar 17 '21 at 18:00