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
Bookmarks