From the course: Excel Power Query Tips and Techniques
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
View monospaced
- [Instructor] So I'm working with these codes, these strings of text, and they should all be the same length, but I'm having problems with them. But how can I see if they are all the same length? I can go to View Monospaced. Now every character gets an equal amount of space and it's easy to see row fives, row nine, and row 12 are longer than the rest. So in this case, something was wrong. Some data has to be cleansed up. Some investigation needs to happen. With monospace, I can see that there's a problem.
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.