Learn Excel Episode 523: Flight Numbers
JJ writes in with a question from Alaska. His home office keeps sending him data with airline in column A and flight number in column B. In order to use this data, he needs to join both values into a single cell. Episode 523 shows how to use concatenation to solve the problem.