The file named Problem12data.xlsx contains in a single cell a states name and population. Use Excel formulas

Question:

The file named Problem12data.xlsx contains in a single cell a state’s name and population. Use Excel formulas to extract the population to a new column. If a new row is added, then your formulas should automatically work on the new data. You may assume no state name consists of more than two words.

Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Question Posted: