Forum Discussion
Solved
adding up from a string of items
Hi I am trying to calculate the total number of people living in the largest 1000 cities in the USA. I can find a table that allows me to copy in this format 986,Addison,Illinois,37385,2.6% ie th...
Select the column with these data.
On the Data tab of the ribbon, click Text to Columns.
Select Delimited, then click Next >.
Tick the check box for Comma and clear the check boxes for other delimiters.
Click Finish.
You should now have the data in separate columns, and you can sum the population figures.