CONCATENATE(string1[,string2...])
CONCATENATE returns up appended strings.
This function is Excel compatible.
CONCATENATE("aa","bb") equals "aabb".
LEFT, MID, RIGHT.