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
Into
001LLAMOR
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
No comments:
Post a Comment