#1   Report Post  
wnfisba
 
Posts: n/a
Default 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
  #2   Report Post  
Dave Peterson
 
Posts: n/a
Default 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
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
pasting data from a website changes text to date stebro Excel Discussion (Misc queries) 8 August 12th 06 08:39 PM
Pasting Text from Outlook into 1 Excel cell giantwolf Excel Discussion (Misc queries) 3 September 29th 05 01:56 PM
Pasting mutiple paragraph text into a single cell Peter Wells Excel Discussion (Misc queries) 2 June 24th 05 02:48 PM
Formulas dealing with text data Bagia Excel Worksheet Functions 6 June 20th 05 10:29 PM
problem when pasting text ew_jammer Excel Discussion (Misc queries) 2 May 29th 05 02:15 AM


All times are GMT +1. The time now is 06:21 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"