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.
---------------------------------------------------------------------------------------------------------------------------
No comments:
Post a Comment