Also read: Arrows keys are not working in Microsoft Excel ... Tip: Use the ampersand (&) symbol to concatenate two text strings. The TEXT function converts the format of a number from ‘numeric ...