Beginning in row $16,$ columns B and C contain raw names and numeric zip codes. In columns D through H$,$ you are asked to clean and manipulate that data in specific ways. Good thing is that you only have to create formulas for the first row then you can fill down. Enter the values for the last row below.

Note: These are meant to be challenging. So just take your time and work thought each column logically using trial and error if necessary.

Hint: The last column for zip code, will require a nested IF function to first see if the numeric zip code is $5$ or $4$ characters long so you then know which formatting to apply.

Proper Name First Name Last Name Short Name $($First L$.)$ New Zip Code

fill in the blank $14$ fill in the blank $15$ fill in the blank $16$ fill in the blank $17$ fill in the blank $18$