ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Pasting text (https://www.excelbanter.com/excel-discussion-misc-queries/51413-pasting-text.html)

wnfisba

Pasting text
 
I am trying to create a formula dictionary for general use in our department.
When I copy syntax and try to paste it into my Excel row, it pastes it but it
pastes each line as a separate row. I tried pasting special, I tried copying
it to Word first and then copying it in, I tried copying it to Notepad first
and then copying it in. None of those seemed to work. Every time I tried
pasting it, it created new rows underneath where I want to paste it for each
line of the syntax.

Any suggestions...

Thanks.

wnfisba

Dave Peterson

Pasting text
 
If you're doing this one cell at a time, just paste into the formula bar
directly.



wnfisba wrote:

I am trying to create a formula dictionary for general use in our department.
When I copy syntax and try to paste it into my Excel row, it pastes it but it
pastes each line as a separate row. I tried pasting special, I tried copying
it to Word first and then copying it in, I tried copying it to Notepad first
and then copying it in. None of those seemed to work. Every time I tried
pasting it, it created new rows underneath where I want to paste it for each
line of the syntax.

Any suggestions...

Thanks.

wnfisba


--

Dave Peterson


All times are GMT +1. The time now is 01:54 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com