yogi_Remove Unwanted Space Character(s) From EMAIL Addresses In Column D

                                          Google Spreadsheet   Post  #1285
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Jul 15, 2013
user Boki7 (http://productforums.google.com/forum/?zx=jqecq75edfbu#!category-topic/docs/spreadsheets/xHbmCYgZkPY)
How to remove empty fields between text in a cell
Hi,

I'm manually importing databases of potential customers into spreadsheet and when I copy/paste email address there are empty fields in email addresses (like: "some .address@ gmail. com"). 

My question is how can I remove empty fields between or in these email addresses? I would like to use search function to delete all empty fields, but don't know how to do that (like: from "some .address@ gmail. com" to "some.a...@gmail.com)?!

Kind regards ;)

----------------------------------------------------------------------------------------------------------------------------------------------