Tuesday, June 14, 2011

yogi_Make Up An ID From Specified Number Of Charecters From Different Cells

Yogi Anand, D.Eng, P.E.                                         Google Spreadsheet                            www.energyefficientbuild.com
garyoh said:
Take three letters out of three different cells and combine them into another cell
I wish to create a unique customer number/reference by combining the contents of the three cells below
a1 001 a2 LLANDUDNO a3 MORRIS Taking the first three characters from each
And place in a new cell
In Sheet1 I have created a formula per garyoh's specification
in Sheet2 I present a more generalized formula using row numbers in column A