Monday, April 14, 2014

yogi_Pull Data Using QUERY Function Where Column B In 'total data' Contains Specified Word regardless Of Its Case (case insensitive query)


                                         Google Spreadsheet   Post  #1602
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Apr-14-2014
post by Samford: (https://productforums.google.com/forum/#!category-topic/docs/spreadsheets/ITxQEceqe5E)
Is it possible to convert all text within a sheet to all lowercase or all uppercase?
I would like to use this formula to extract data from a master sheet:

=query('total data'!A3:D,"Select * Where B contains """&B2&""" ")

It works really well, but I am finding the "contains" option will only return matching case text from the B column. I figure if I can format all the text in the 'total data' B column to be either upper or lower case, then the problem is solved!

I'd be most grateful for any solutions or other suggestions.
---------------------------------------------------------------------------------------------------------------------------