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

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

edit-replace, enter a space without quotes in find what and nothing in
replace with and then replace all. HTH

"Mohamed" wrote:

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

try this

Sub trimem()
For Each c In Selection
c.Value = Application.Substitute(c, " ", "")
Next
End Sub

--
Don Guillett
SalesAid Software

"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