I have a student list. the format is given below.
COLUMN A COLUMN B
Stud_Name Stud_No
Ragul 101
Abishek 102
Guna 105
Jenifer 108
Lenin 104
While entering the student no in C1 the student name should display in D1.
For that i am using...
Hi All,
I am using the concat code of Chandoo to concatenate a range of cells.
It's very useful for me.
The result of the code is like this.
Eg:-
A1= APPLE
A2= ORANGE
A3= BANANA
while executing the concat code the result will be like this. [=CONCAT(A1:A3),,)]
APPLE,ORANGE,BANANA...