CONCATENATE(s1,s2,…)
s1: first string
s2: second string
This function is Excel compatible.
LEFT, MID, RIGHT.