solution: how to sum/add a column pasted from internet
 

Numbers pasted from online bank statements often have a space
character in front of the number values -- as though someone had hit
the space bar in each cell before typing the number. You have to get
rid of the spaces.

You can either manually delete each extra space at the front of the
number, or, paste the numbers into Word, and do a Find & Replace All
for the space, so that all the spaces are removed (a function I
couldn't find in Excel).

Once the spaces are gone, your problem should be solved.

Did you try the TRIM Function to get rid of leading and trailing spaces?

=TRIM(A1) will remove extra spaces.

Drag/copy as far as you need.

Unless they are html non-breaking spaces, for which there are other methods.

See David McRitchie's TrimAll code.

http://www.mvps.org/dmcritchie/excel/join.htm#trimall


Gord Dibben Excel MVP



On 9 Apr 2005 10:36:51 -0700, (willem) wrote:

Numbers pasted from online bank statements often have a space
character in front of the number values -- as though someone had hit
the space bar in each cell before typing the number. You have to get
rid of the spaces.

You can either manually delete each extra space at the front of the
number, or, paste the numbers into Word, and do a Find & Replace All
for the space, so that all the spaces are removed (a function I
couldn't find in Excel).

Once the spaces are gone, your problem should be solved.

Thanks for the trim suggestion. I also noticed afterward that there's
an option from the site to download the data in a variety of formats.
There's no problems with spacing if done this way.

willem

Thanks for the feedback.

Glad you're sorted out.

Gord

On 10 Apr 2005 12:10:37 -0700, (willem) wrote:

Thanks for the trim suggestion. I also noticed afterward that there's
an option from the site to download the data in a variety of formats.
There's no problems with spacing if done this way.