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
following is a solution based on my understanding of what the user asked for
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
No comments:
Post a Comment