🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: comp.apps.spreadsheets
Article #119

Re: Help! Paste Special in Excel (v2.2, Mac)

#119
From: halsema pb 64533
Date: Tue, 25 Aug 1992 18:31
33 lines
2165 bytes
redgers@ee.ic.ac.uk (Adrian Redgers) writes:
: In MS Excel 2.2 for the Macintosh, after you've done a calculation and
: you want the the results - *not* the formulae - how do you get at them?
: 
: For example I might want to take the results and "Save As..." an MS
: Word document.  Currently I get the formulae :-{

Try doing "Save As..." and setting the file type to text (use the options
button to get at that).  This will save the values as tab delimited text.

: In MS Works there is a command called "Paste Special..." (spreadsheet, 
: Edit menu).  In Excel "Clear..." (Edit menu) looks a bit similar but
: clearing formulae clears the results as well.  Grrrr!

"Clear..." is used for just that, clearing fields.  "Paste Special..." can
be used to paste the values only (i.e. no formulas) into another worksheet.
This won't help you get into Word, unless you want to:
	 1) select range of interest
	 2) copy
	 3) go to a blank space or new worksheet
	 4) select "Paste Special..." values
	 5) copy
	 6) go to Word and paste
Depending on what you're doing either this approach or the save as 
approach will do the job.

   ---Paul
_______________________________________________________________   _________
Paul Halsema               \\      AT&T: (407) 729-3536          |  _   _  |
Harris Corp., GASD          \\ INTERNET:                         |_| |_| | |
MS 102-4827 PO Box 94000     \\   phalsema@x102a.ess.harris.com  |_/\/\/\|_|
Melbourne, FL 32902           \\                                 | |_| |_| |
_______________________________________________________________  |_________|
Technical Details
Message-ID: <1992Aug25.183141.18851@mlb.semi.harris.com>
Path: arc1-ca.pugleaf.net!sparky!uunet!haven.umd.edu!darwin.sura.net!mlb.semi.harris.com!x102a!phalsema
References: <1992Aug25.115108.22993@cc.ic.ac.uk>

Show Full Headers
Complete Article Headers
Newsgroups: comp.apps.spreadsheets
Path: arc1-ca.pugleaf.net!sparky!uunet!haven.umd.edu!darwin.sura.net!mlb.semi.harris.com!x102a!phalsema
From: phalsema@x102a.ess.harris.com (halsema pb 64533)
Subject: Re: Help! Paste Special in Excel (v2.2, Mac)
References: <1992Aug25.115108.22993@cc.ic.ac.uk>
Date: Tue, 25 Aug 1992 18:31:41 GMT
Nntp-Posting-Host: x102a.ess.harris.com
X-Newsreader: Tin 1.1 PL4
Organization: Harris ESS, Melbourne, Fla.
Sender: news@mlb.semi.harris.com
Message-ID: <1992Aug25.183141.18851@mlb.semi.harris.com>
Lines: 33