Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
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. |
#3
|
|||
|
|||
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. |
#4
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I sort by row instead of by column? | Excel Worksheet Functions | |||
up to 7 functions? | Excel Worksheet Functions | |||
How do I reference every "n" cell in a column in Excel? | Excel Worksheet Functions | |||
Pasting all but Column widths doesnt get pasted. | Excel Discussion (Misc queries) | |||
How can I sort an entire spreadsheet from a list | Excel Worksheet Functions |