One of my favorite formulas for data cleanup in Excel – and I didn’t know I could use it in SharePoint. Winner winner chicken dinner if you ask me – this would fix a lot of that nasty Single line of Text additions. Let’s take a look at how we can use =Upper, =Lower and =Proper to make text looks better in SharePoint.

Purpose of this blog challenge:  I will write 365 blogs in 365 days around Microsoft 365. I did a similar challenge with Office 365, blogs can be found  https://atomic-temporary-35693276.wpcomstaging.com/microsoft-365/ . I won’t just be talking about the new Microsoft 365 subscription model. I will be sharing any news, tips and tricks around Office / Office 365 / Windows / Mobility and Security. And let’s not forget all the great new Apps & services available.  A lot of what I’ll share on Office and SharePoint will also be applicable to none “Office 365” versions.

“You can also find me contributing to REgarding 365. I’m a member of a group of enthusiasts, sharing their stories, thoughts and opinions about Microsoft 365. Catch us at https://regarding365.com | @regarding365 on Twitter and regarding365 on YouTube https://www.youtube.com/regarding365 ”

Disclaimer:  I create content about Office / Microsoft 365. Content is accurate at time of publication, however updates and new additions happen daily which could change the accuracy or relevance. Please keep this in mind when using my blogs as guidelines.