The simplest function for text strings is to “add” them together — concatenation: Basic text functions
Extract part of a text string with LEFT(), RIGHT(), MID(), LEN() and FIND(): Working with parts of a text string
Control the case of strings with LOWER(), UPPER() and PROPER(): Adjusting the case of a text string
Find and replace parts of text strings with SUBSTITUTE(): Find and replace in text strings