Functions such as PROPER, LEN, LEFT, and RIGHT allow you to clean up and parse text information that may arrive to you in a less than ideal format. Practice using these functions in cells D$2$:D$5$ using the data in column C$.$

Name data to proper case: fill in the blank $2$

Audrey Mullins

Number of characters in a text string: fill in the blank $3$

$6$

Find first $4$ characters of a text string: fill in the blank $4$

Mull

Find final $3$ characters of a text string: fill in the blank $5$

ins

While LEFT and RIGHT are straightforward, the MID function will provide the middle portion of a text string. You just need to tell it where to begin and how many characters you want after that location.

Get three characters from a text string starting on the third character: fill in the blank $6$