[R-sig-eco] NMDS vegan

John Jay Wiley Jr. jwileyjr at syr.edu
Wed Oct 27 16:31:15 CEST 2010

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]

John J. Wiley, Jr.
PhD student
Dept. of Env. For. Bio.
1 Forestry Dr.
Syracuse, NY 13210


Date: Tue, 26 Oct 2010 14:30:28 -0400
From: Soumi Ray <soumiray74 at gmail.com>
To: r-sig-ecology at r-project.org
Subject: Re: [R-sig-eco] NMDS vegan
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.


More information about the R-sig-ecology mailing list