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 L2 into its own column?
1 point
=RIGHT(5,L2)
=LEFT(5,L2)
=LEFT(L2,5)
=RIGHT(L2,5)