21.7 Select Case
Create a UDF named “Direction” that uses the Select Case method to change the abbreviations N, S, E, and W into their full names of North, South, East, and West. If done properly, the blue boxes below will populate with the correct answers.
Figure 21.8: Sample data for Direction function.
This function is very simple and implements what is required.