Mark Snell . com

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

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

%d bloggers like this: