All Questions
7
questions
0
votes
0
answers
2k
views
Excel - paste *only* number formatting
Is it possible to copy/paste only number formatting in Excel.
There are various paste special options.
In particular Formulas/Number Formats and Values/Number Formats. But is there a way to paste only ...
0
votes
1
answer
432
views
Can't remove hidden characters?
I'm trying to make a simple tool for my job where I can decline job listings for a specific reason simply by checking their boxes and then copying and pasting the final cell where it will compile all ...
0
votes
1
answer
4k
views
How to copy from excel rows to word paragraph
How to copy from excel rows to word paragraph.
ex data from excel
1. robin d123 e123
2. morgan f123 e456
paste to word become:
1.
robin
d123
e123
2.
...
1
vote
1
answer
2k
views
Why is copy paste losing all formatting by default?
Lately whenever i copy paste something (in particular within Office) by default i lose all formatting. To copy the formatting have to retry copying the content several times before it works.
So far i ...
67
votes
11
answers
262k
views
Excel copy-paste: always match destination formatting
I use Excel to crunch numbers, so I usually don't want to copy the formatting along with the text. But this is the default. Is there a way to default to always match destination formatting when ...
107
votes
23
answers
247k
views
How to copy multi-line text from Excel without quotes?
When you create a multi-line string in an excel cell (by using Alt-Enter), if you copy that cell to a text editor, excel will automatically add double quotes (") around the full string, ie:
Cell1 | ...
6
votes
3
answers
19k
views
Paste to Excel from clipboard (plain text) : Can I make certain cells to be formatted "as such"
when preparing table data as text to be copied to Excel through clipboard, is it possible to have certain cells unformatted? (If possible, without changing Excel settings or doing a special paste).
...