Useful Excel Expressions

=UPPER( )
This function will change the case of a specified cell to upper case.

=LOWER( )
This function will change the case of a specified cell to lower case.

=PROPER( )
This function will change the case of a specified cell to title case (ie The first letter of each word in the cell will be capitalised).

Splitting Data

1. Select the cells containing the data you want to split
   NOTE: Excel will split only one column at a time.
2. From the Data menu, select Text to Columns…
   The Convert Text to Columns Wizard – 1 of 3 dialog box appears.
3. Under Original data type, select Delimited