Thursday, August 9, 2012

yogi_Extract Contents Of Sheet1 Into yogi_Sheet To Have Certain Words Wrapped In Double Quotes

Yogi Anand, D.Eng, P.E.       Google Spreadsheet    Post  #682   Aug 09, 2012     www.energyefficientbuild.com.

user ewtkquestion said: (http://productforums.google.com/forum/#!category-topic/docs/spreadsheets/CPAfYk_kWRA%5B1-25%5D)
adding a given symbol to multiple, uniquely populated cells
hi
i'm trying to add "" around the copy within hundreds of uniquely populated cells. as the individual, unique cell copy already exists, i have been unable to figure out a system that will apply the addition of " at the beginning and end of each cell systematically without altering the unique copy in the transformation. 
ideas?
in other words, i am just trying to to alter cells (both rows and columns) that read: dog / tree/ ocean to read: "dog"/ "tree"/ "ocean"
you'd be saving me hours of tedious work, and i'd be forever grateful.
thanks!
-----------------------------------------------------------------------------------------

following is a solution based on my understanding of what the user asked for