Excel Formula

Creating Email ID from Student ID

For First Degree Student = CONCATENATE ("f",MID(A1,1,4),MID(A1,9,3),"@dubai.bits-pilani.ac.in")