There are nearly 500 Excel functions, and the list continues ... put first and last names together. Other common use cases are completing an address, reference number, file path, or URL.