Excel's text functions extract, join and clean up strings of characters: GAUCHE (LEFT), DROITE (RIGHT) and STXT (MID) extract a part, CONCAT and JOINDRE.TEXTE (TEXTJOIN) join, SUPPRESPACE (TRIM) removes extra spaces, MAJUSCULE (UPPER) and MINUSCULE (LOWER) change the case, TROUVER (FIND) and SUBSTITUE (SUBSTITUTE) locate and replace. They prepare heterogeneous data.
Example
=GAUCHE(A2;3)&"-"&SUPPRESPACE(B2)