Convert Text to Columns: The selected column contains a list of airport codes and the location on the airport. Split the selected column, using the common delimiter, a colon (:), so that the airport codes are in column K and the airport locations are in column L

🎲 Try a Random Question  |  Total Questions in Quiz: 55  |  🧠 Study this quiz with Flashcards
This question is part of a full practice quiz:
Prove It - Microsoft Excel 2 — practice the complete quiz, review flashcards, or try a random question.


1. Convert Text to Columns: The selected column contains a list of airport codes and the location on the airport. Split the selected column, using the common delimiter, a colon (:), so that the airport codes are in column K and the airport locations are in column L