Microsoft Office Tutorials and References
In Depth Information
LOWER converts all letters in a text string to lowercase.
The LOWER function is primarily a cleaning function. If you have inconsistent data in lists and you
want all characters to result in lowercase, simply use the LOWER function. Notice the example in
Figure 12.7. The LOWER function converts all the uppercase names to lowercase. Use Paste Special
and paste as values back into the original location in the list after you’ve converted all characters
to lowercase. This function can be used with text in a cell or with cell referencing as shown.
This is the text within the cell you want to convert to lowercase characters.
Use the LOWER
function to clean
lists of information
that are inconsistent.
MID Use the MID function to return a specific number of characters from a text string, starting at
the position you specify.
The MID function returns a specific number of characters from a text string. You can use text
within the formula or use cell referencing. If you take a look at the example in Figure 12.8,
you’ll notice that =MID(“Chris”,1,4) only returns the first four characters in the string. The
second example =MID(“Hobbe”,2,4) returns the text string starting with the second character
in the string, Hobbe. Combined with the FIND function and used with cell referencing, you
can extract first names in text strings. For example, =MID(C11,1,FIND((“ “,C11)-1) returns
the result of the first text string to the left of the first space. The FIND function locates the
space based on a space in quotes.