Monday, May 23, 2011

yogi_Extract Entries Starting With ? From Spreadsheet Cells

Yogi Anand, D.Eng, P.E.                                         Google Spreadsheet                            www.energyefficientbuild.com
henry922 said:
For example here's a spreadsheet with texts
A B
---------
?apple banana
orange pear
mango ?melon
And my expected output:
?apple
?melon
Any ideas? I'm new to google docs...

---------------------------------------------------------------------------