Message-ID: <AD82EC0E2CED0E47BA8AA205DD7BD20A51F85439@BL2PRD0103MB038.prod.exchangelabs.com>
Date: 2010-10-27T14:31:15Z
From: John Jay Wiley Jr.
Subject: NMDS vegan
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 at gmail.com>
To: r-sig-ecology at 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