Yogi Anand, D.Eng, P.E. Google Spreadsheet Post #790 Oct 02, 2012 www.energyefficientbuild.com.
user Ryo-angii said: (http://productforums.google.com/forum/#!category-topic/docs/spreadsheets/NyOrpEpu5C0)
How can I concatenate four values to create an index column?
A spreadsheet has multiple columns, Index, StreetNumber, StreetName, UnitNumber, District etc I would like to set the value for Index as Streetnum:Streetname:Street unit: District. (any separator will do) as each row is filled in from the form.
user Ryo-angii said: (http://productforums.google.com/forum/#!category-topic/docs/spreadsheets/NyOrpEpu5C0)
How can I concatenate four values to create an index column?
A spreadsheet has multiple columns, Index, StreetNumber, StreetName, UnitNumber, District etc I would like to set the value for Index as Streetnum:Streetname:Street unit: District. (any separator will do) as each row is filled in from the form.
I seem to be able to only concatenate the first two values using the CONCAT function.
Using MacBook Air
---------------------------------------------------------------------------------
following is a solution to the problem
No comments:
Post a Comment