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 <soumira...@gmail.com> To: r-sig-ecology@r-project.org Subject: Re: [R-sig-eco] NMDS vegan Message-ID: <aanlktingfquijcucl9tdsvh015wygmdfpznzojmfk...@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 https://stat.ethz.ch/mailman/listinfo/r-sig-ecology