Tuesday, July 23, 2013

yogi_Filter Data With Unwanted Space Characters in Cells Of Source Data

                                          Google Spreadsheet   Post  #1303
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Jul 23, 2013
user Billy Hicks (http://productforums.google.com/forum/?zx=e1rxqtn7rta2#!category-topic/docs/spreadsheets/-uK-gysxlYM)
Auto Sort / Filter on Google Spreadsheet -- doesn't work if space is entered after word is typed in cell

My spreadsheet filters and auto sorts onto multiple pages very well except in one situation. If someone types a space after "January" or "February" etc., it will not filter to the following sheets. Is there something I can do to fix that?

Thanks in advance. 
in the following solution for a bit more generalized problem, I have considered the possibility of unwanted space characters in source data as well as search field that i have created in cell A1 of yogi_February