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
https://docs.google.com/a/csisd.org/spreadsheet/ccc?key=0Ah2HUlVm8DGmdERIRDBiQkpwSzQ1R3VnaWtCeE5sSGc#gid=0

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. 
BH
-----------------------------------------------------------------------------------------------------------------------------------------
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

No comments:

Post a Comment