paste special / skip empty cells doesn't work!?

[Ivica TypeR]

have two columns and column B want to paste special with skiping empty
cells into column A (in column A where need to paste there ARE empty
cells) and my excel 2003 paste it all as normal paste! don't get it
what is problem but i'm sure before was working this fine!?

example:

Column A Column B


1,80 - 1,90

2,3 - 2,4
1,50 - 1,60
1,9 - 2,0
2,3 - 2,4
1,40 - 1,50


2,1 - 2,2
1,70 - 1,80

so this what is in B want to transfer into A but not to delete present
data in A!?

 

[Ivica TypeR]

i see now that with number and even text this copy/special paste/avoid
empty cells.. is working, but with this type of text which i provided
there is not working.
Why, and what should i do to change it?

 

[Ivica TypeR]

this is crazy, i can't anyhow do this which should be very simple and
i'm stuck and i'm in a hurry and i'm struggling with this for two hours!!!

can someone try this? i can send you on e-mail smaller part of this file
to try it working?!

i would be very thankfull

 

[Ivica TypeR]

i've done it in a way that every column need to go to data / text to
column !!!! and whole column put again as column...

and working later with paste special with empty cells...


Totaly weird!