95 Excel Tips & Tricks for Making Your 9 to 5 Better

Also try lower() and upper() as well to change excel cell value to lower and UPPER case 2. Clean up textual data with trim, remove trailing spaces Often when you copy data from other sources, you are bound to get lots of empty spaces next to each cell value. You can clean up cell contents with trim() spreadsheet function. ................
................