Posted: April 23rd, 2017
If you have a table with city, state, and zip code merged together in column C and use the Convert Text to Columns Wizard to separate the data into three fields, you need: (Points : 2)
Empty columns to the right of column C.
Empty rows at the bottom of the worksheet.
Empty columns to the left of column C.
Empty rows at the top of the worksheet
Place an order in 3 easy steps. Takes less than 5 mins.