Delete space

[Guest]

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

 

[JulieD]

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

 

[Guest]

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

 

[Don Guillett]

try this

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