- 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

The following are some tips on functions of value in working with multiple wordlists.

First draft of our*aide memoir.*

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**. A list of all available functions and aid selecting cells and help with the function._{n}**=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.]

**=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. - One way to disguise an email address to avoid spam.