Import the text into Excel. The column delimiter is the minussign, ‘-‘. Make a table of the total population of each city ineach state in excel and post all steps used.
State Code-County Code-City Code-Population
2-117-13-49174
4-134-21-72247
3-137-27-91811
8-140-13-13913
4-133-16-11028
1-119-12-37710
10-101-31-76485
8-138-16-82956
6-125-26-67320
2-108-19-27973
6-119-22-25359
8-122-17-16881
4-140-18-63178
2-111-13-53192
2-112-30-31156
1-127-19-37547
9-135-23-48125
3-108-19-61645
6-113-26-16166
5-112-31-17847
7-135-23-48441
5-124-15-20688
6-106-15-95046
3-105-16-35144
6-120-29-97858
9-117-26-19441
6-120-18-71854
2-114-24-80466
3-138-15-73195
3-104-28-62538
1-133-24-74205
2-126-11-56200
3-129-15-41400
8-121-21-13075
10-138-19-57237
8-112-21-99683
2-114-13-70453
4-113-28-33874
9-112-23-23172
6-105-18-74177
7-140-21-11851
1-115-28-28103
5-134-20-48211
6-114-20-51120
3-111-24-55273
7-119-28-19041
8-122-29-19288
3-134-11-94750
9-119-26-62117
6-138-21-66254
4-117-29-21650
2-135-28-31025
5-135-24-30519
10-118-27-22788
9-102-19-92033
1-138-22-49667
2-101-24-81847
3-122-20-13381
3-124-18-34141
6-140-17-52557
6-131-28-23671
2-126-12-15206
7-124-23-28605
10-101-23-85366
10-106-19-57824
4-132-21-53104
3-119-29-51525
4-107-30-53327
5-108-17-97390
5-128-26-24022
3-117-19-37134
7-135-17-64097
3-140-31-93398
10-129-19-30970
2-112-12-85156
6-136-29-52765
5-121-21-73339
4-113-27-54497
8-113-22-94934
8-138-12-51563
