Monday, October 1, 2012

yogi_Concatenate Streetnum Streetname Street unit And District Columns Into Index Column Row By Row

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. 
 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