Hi

Im new here and i thought maybe there are some excel experts in here that could help me with (probably a VERY simple question) but i have no clue what todo.
So please help if you can.


Anyways, this is what my line(s) looks like in Excel 2007.

01/31/2011 - 07:50 4 491 01/31/2011 - 17:04 4 723

As you can see 4491 and 4723 have spaces between 4 and 4 , 4 and 7
I simply want to make a macro that delete thoose spaces

(i tried ctrl+h, replace...but quickly found out that how do i enter a delete command and a space command?? probably not the way togo.)

Furthermore, a macro for this might not even be nessesarry, what im trying to do is simply
subtract 4491 from 4723 (D27-B27), but as long as it is a space there i get #wrongvalue
IF i take away the space, no problems at all.

Hope you understood what i'm talking about my english isnt the greatest, but it seem like a basic excel problem.

Thanx

/Doggen