Monday, July 15, 2013

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   Jul 15, 2013
user Boki7 (!category-topic/docs/spreadsheets/xHbmCYgZkPY)
How to remove empty fields between text in a cell

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 "!

Kind regards ;)