Hi Mohamed

do you want to delete ALL spaces in the cell?

if so, i would use edit / replace
Find What: press your space bar
Replace With: leave blank
Click the replace all button
(please try this on a copy of your workbook first just in case the results
are what you want)

if not, is the space always in the same place in the cell, ie it's always in
the fourth position?

Hope this helps
Cheers
JulieD



"Mohamed" wrote in message
...
Hi,
How can i delete space between letters & numbers in each cell , i have
10000
row and i want to delete spaces between letters & numbers in each cell ,
and
i think that will take me alot of time to do it manualy.

Thanks