In: Advanced Math
Import the text into Excel. The column delimiter is the minus sign, ‘-‘. Make a table of the total population of each city in each 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
first of all copy and paste the data in your excell row wise like
2-117-13-49174
4-134-21-72247
...
...
8-138-12-51563
then use delimiter of "-" as to seperate them as the columns
Split the content from one cell into two or more cells
then click on next
here i have took first country code then i have kept state code
by just copy paste after the seperating them into columns
now after that sorting them in ascending order
select the column you want to sort then
To sort a range:
finally it looks like this
please give good rating