Thank you for that hint. Very useful to know.

Is there a way to also replace all cells with a particular numeric value (e.g. every cell with 76) with another number or letter?

_____________________________________

Burak K. Pekin, PhD
Postdoctoral Research Associate
Department of Forestry and Natural Resources
Purdue University
195 Marsteller Street
West Lafayette, IN 47907
email:  bpekin@purdue.edu<mailto:bpekin@purdue.edu>
tel:  +1 765 496 1216
_____________________________________



This is not necessarily an R method, but may be useful to some.



In Excel, one can quickly replace blank cells with a particular value (e.g., 0, NA) by the following method:



1) Select the data region

2) ctrl+g (Go To)

3) Click "special"

4) Select "blanks"

5) Click "OK" [All blanks will now be selected, and one blank will be the active cell]

6) Type "0" [or NA, etc.]

7) ctrl+enter [All selected blanks are now filled with 0's]



Cheers,

John J. Wiley, Jr.

PhD student

Dept. of Env. For. Bio.

SUNY ESF

1 Forestry Dr.

Syracuse, NY 13210

740.590.6121



----------------------------------------------------------------------



Date: Tue, 26 Oct 2010 14:30:28 -0400

From: Soumi Ray <soumiray74@gmail.com>

To: r-sig-ecology@r-project.org

Subject: Re: [R-sig-eco] NMDS vegan

Message-ID:

        <AANLkTinGFQuiJCucL9tdsVh015WygMdFPznzoJMfKfD=@mail.gmail.com>

Content-Type: text/plain



Hi all,

It worked when I replaced the blanks (missing) in my spreadsheet as NA and saved it as csv.

Stephen, my data is in excel spreadsheet, I have no clue how to replace all the blank cells in the huge dataset as NA.



Thank for the help.



Soumi



_______________________________________________

R-sig-ecology mailing list

R-sig-ecology@r-project.org<mailto:R-sig-ecology@r-project.org>
https://stat.ethz.ch/mailman/listinfo/r-sig-ecology

	[[alternative HTML version deleted]]

