Proper & Trim to clean up data
Proper Website: https://support.microsoft.com/en-us/office/proper-function-61db8dc3-a6ca-456e-ab1b-e93ad47da569#:~:text=Capitalizes%20the%20first%20letter%20and,text%20string%20to%20lowercase%20letters. PROPER(text) Text is text enclosed in quotation marks, a formula that returns text, or a column reference containing the text you want to partially capitalize. Trim Website: https://support.microsoft.com/en-us/office/trim-function-410388fa-c5df-49c6-b16c-9e5630b479f9 TRIM(text) The TRIM function syntax has the following arguments: Text Required. The text from which you want spaces removed. As a Project Analyst, I used both the proper and trim functions to clean up payroll excel files of employee names. Not only is this important for making your work look clean, but also trim is essential for making sure your conditional formatting worked. If "John " (with a space) and "John" (no space) are checked for exact match using conditional formatting, it will not hig...