CONCATENATE(string1[,string2...])
CONCATENATE returns the string obtained by concatenation of the given strings.
CONCATENATE("aa","bb") equals "aabb".
LEFT, MID, RIGHT.