I have copy some data from a website. And copy to Excel Sheet.

Now i trying to Sum the total of column but neither Autosum nor Sum Function
Work.

There are Space after the Numbers. I tried Trim Function but it is not
Working.

=trim(A1)

Anybody can help me

Hardeep kanwar