In Part One of this blog post I covered 5 ways to clean up your data. In this one I am going to cover 5 more
- Change Case
- Concatenate (like many things in Excel – not as exciting as it sound…)
- Left/Right/Mid
- Text Before/ Text after
- Using Len
You can download the completed file here.
You can view the video here