how to remove spaces in a middle of a cell example '25 566 589.

hi
iam facing this problem in my excel database because i want to export this
data to sql server 200 this cell contains a phone nos.

regards
P.M.SANJAY

Make a copy of you file before doing this:
Select your column - goto Replace
In the find area - press your spacebar 1 time
In the Replace Area - Enter what you want to replace it with - if you want to replace it with "nothing" just leave it blank.
This will remove "ALL SPACES" between your numbers
If you want to replace "spaces" with "-" then enter that into your replace area. If you then get more than "-" just do a find "--" and replace with "-"
Leave the "" out in the replace with.