At this point, you notice that the information about state and zip code is in the same cell. However, your company$$s mailing list software requires states to be on a separate line from zip codes.

What function do you use to move the $5-$digit zip code in cell L$2$ into its own column?

$1$ point

$=$RIGHT$(5,$L$2)$

$=$LEFT$(5,$L$2)$

$=$LEFT$($L$2,5)$

$=$RIGHT$($L$2,5)$