TIPS

---

• Hide Email Address
• Spreadsheet Functions
  
  Never put another person's e-mail address on your web page without disguising the address.
  
  
  • One way to disguise an email address to avoid spam.

    Contact us at :
    <script language=javascript><!-- //
    var link   = "E-mail";
    var tag1   = "mail";      var tag2   = "to:";
    var email1 = "%20manor1"; var email2 = "basic-english";
    document.write("<a href=" + tag1 + tag2 + email1 + "@" + email2 + ".org>" + link + "</a>")
    // --></script>
    

    appears as:
    
    Contact us at :

    ---

  Excel Spreadsheet Functions
  First draft of our aide memoir.

  The following are some tips on functions of value in working with multiple wordlists.
  DATA | GET EXTERNAL DATA | IMPORT EXTERNAL DATA
  Select a data file | tell if in fixed column widths or delimited.
  Many wordlists are horizontal and delimited with commas, CSV.
  The Institute has some data already in spreadsheet format, email a request. Symbols:

  =	what follows starts a formula or function.
  $	make the cell firm. A$1
  :	a range of values. A$1:A$9
  :	An entire column. A:A

  
  TOOLS | OPTIONS | EDIT has some things.
  DATA | SORT
  Drag -- click on a function cell then click and hold and drag to repeat the formula. in other cells. The cell names will index. Cells with $ will not.
  Paste Special, select [ ] values will put the values, not the forumlas
  Functions -- tool bar symbol f_n. A list of all available functions and aid selecting cells and help with the function.
  =TRIM(A1)   will remove blanks.
  Blanks, spaces, nulls cannot be seen; sometimes they exist and sometimes they don't --. an "a followed by a space" will not match an "a" The solution is to trim away all spaces, except one between words.
  In column B, enter the function =TRIM(A1)
  Column B will seem the same as A, but it really contains the function TRIM formula..
  Select column B and Paste Special | [ ] Values into column C.
  =CLEAN(C1) will remove non-displayable characters other than spaces.
  =IF(test,do if true,do if false)  
  =IF(A2=A1,"duplicate","")   show duplicates
  =IF(A2=A1,"",A1)   remove duplicates
  =FIND(text,A1)   give starting location of character sought.
  =LEFT(A1,length)   will keep first part of word.
  =IF(FIND("'s",A1)>1,LEFT(A1,FIND("'s",A1)-1),A1)   remove 's. However words without 's will generate an error instead of an answer. Therefore a second step is required.
  [@#$%& M$, ... err, MS has inadequate quality in its expensive product offerings.]
  =ISERROR(a1)   returns logical true or false of error condition.
  =IF(ISERROR(B1),B1,LEFT(B1,FIND("'s",B1)-1))   Remove 's
  MATCH(B1,A:A,0) find matches,. 0 is exact match , returns row number
  Sometimes gives the error #N/A
  =ISNA(value)   value of #N/A yields true, else false
  =IF(ISNA(MATCH(A1,B:B,0)),A1,"")   Compare each word in column A and every word in B and select words from A that are not in B. Used to compare Basic, VOA and Freq wordlists.
  =IF(CODE(LEFT(A1)) < 91,A1,"")   yields capitalized words
  =IF(CODE(LEFT(A1)) < 91,"",A1)   yields uncapitalized words.
  CODE returns the computer code for the leftmost character. Codes for uppercase letters are 65 to 90 ; lowercase letters are from 97 to 122.