Use this utility to grab lines from a file. Arguments are the input file, starting ling number and ending line number.

Function to capitalize the first letter in every word in a string, but only if the entire string is in ALL CAPS.

Example:
"I LIKE TO SCREAM" becomes "I Like To Scream"
"I LIKE to RUN" remains "I LIKE to RUN".

Excel macro to group and count the number of items in a range of cells, delimited by the pipe character "|". It returns a summary of the items including a percent of total and count for each item found, plus a grand total of all items.

Currently limited to 100 items, simple becasue I didn't have the time to spend to get dynamic arrays to work.

Sample Data:
--------------
cat|dog|bird
--------------
cat|bird
--------------
cat
--------------
frog

==================
OUTPUT from =total(A1:A4)
==================
42.9% - 3: cat
28.6% - 2: bird
14.3% - 1: dog
14.3% - 1: frog
---
7

Sanitize form input using CGI.pm to prevent XXS & SQL injections: