The future of otolaryngology is in your hands
As practice managers, administrators, coders and more, you are constantly challenged to promote the best in otolaryngology medicine across your region and across the country while simultaneously running a successful business. The Association of Otolaryngology Administrators is your partner to help make that happen.
The AOA is the only association dedicated to otolaryngology practice management. Our specialty-specific education, resources and networking opportunities will help take your practice to the next level and remain competitive in an uncertain time of healthcare.
11/7/2018 EXCEL CLEAN AND TRIM FUNCTIONS
Have you ever copied data into an Excel spreadsheet only to find extra spaces or returns added? Cleaning that up is time consuming and annoying - but there is an easier way. You can TRIM cell contents to remove extra spaces, leaving no spaces before or after the text and only one space in between all words. Simply put your cursor in another column where the new cell entry should appear and type =TRIM(cell location). If you have extra or unwanted returns in a copied entry, type =CLEAN(cell location). This removes those extra returns. And if you have both extra returns and extra spaces, you can do this all at once by typing =CLEAN(TRIM(cell location)). Once completed, copy and paste SPECIAL back into the original location you want the data to get rid of the formulas and just paste the cell contents formatted the way you wanted. This is definitely something you should do if you are using pivot tables and find what looks like duplicates in your data. It might just be that one little pesky extra space.
Read the Manager's Minute Archives.