I'm trying to copy and paste text from a cell. I want the cell to read
+ events. I need to add a quote so that it's not interpreted as an incorrect formula, so the cell is
'+ events and reads
But when I copy and paste the text
'+ eventsCmd, the single quote
' is not masked, so the cell is
'+ events but still reads
- Why does it behave like that, and what can I do about it? I could copy the cells itself but I would also paste formatting and it's not much better.
- If I can paste text without it being formatted, why can't I paste
+ eventswithout Excel adding an
Here's a screenshot, the second cell has the same content as the first one but the
' is not masked. This happens when I paste the text directly on the cell, not if I paste it in the top bar (but that takes twice as many time).
I'm using Excel 2013 from the Microsoft Office Professional Plus 2013 suite.