Using Google Sheets Text Functions to Clean and Format Data in a Sheet

sheets
2
0
Prompt
How do I use the Google Sheets Text functions (e.g., UPPER, LOWER, PROPER, CONCATENATE) to clean and format data in a sheet?