Excel Adding duplicated numbers together

I am importing a .txt file from a portable data collector to Excel. I can't
figure out how to get the program to recognize duplicated numbers in order to
add them together. The .txt file reads like this:
33110003,2

The ',2' is the count from the .txt file but does not add other numbers
together that are the same. So when I read the file on excel it looks like
this:
33110003,2
33110003,4

I want it to be this way:
33110003,6

Please help, thank you!

When you import the data, put each of those fields into its own column (comma
delimited???).

Then you could sort by column A and then Data|subtotal.

Or even use a pivottable to get the totals.



JJ Joobler wrote:
>
> I am importing a .txt file from a portable data collector to Excel. I can't
> figure out how to get the program to recognize duplicated numbers in order to
> add them together. The .txt file reads like this:
> 33110003,2
>
> The ',2' is the count from the .txt file but does not add other numbers
> together that are the same. So when I read the file on excel it looks like
> this:
> 33110003,2
> 33110003,4
>
> I want it to be this way:
> 33110003,6
>
> Please help, thank you!

--

Dave Peterson