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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
Back
Top