What it does: The TEXT() function takes a text input and formats the text according to format you select.
Plain English: Many times, you’ll encounter incorrectly formatted data that you need to clean up for your projects; numbers formatted as text, dates formatted as strings, etc.. This function helps you clean up the “noise.”
Arguments: TEXT(string,format)
- String – The string you want to format.
- Format – The format you want to change the string to.