Thread: [Solved] Find and Replace
View Single Post
 
Old 08-12-2011, 10:49 PM
Catalin.B Catalin.B is offline Windows Vista Office 2007
Expert
 
Join Date: May 2011
Location: Iaşi, Romānia
Posts: 386
Catalin.B is on a distinguished road
Default

you can use this formula in another column: =SUBSTITUTE(D8;" ";"")
or, with find and replace, in find what line type a space, in the replace with, do not type anything; just click replace all...this should work... good luck!
Reply With Quote