Excel

TRIM&CLEAN SPLIT COLUMN If I received a payroll report from a client during my role as a Project Analyst at Incentax, I would use power query to clean up the report by capitalizing first letter of each word, removing trailing spaces, and splitting the columns to separate first and last name. Thus, it is now in a clean and usable format to copy into a templated file.

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...