Did you like how we did? Rate your experience!

Rated 4.5 out of 5 stars by our customers 561

Award-winning PDF software

review-platform review-platform review-platform review-platform review-platform

Video instructions and help with filling out and completing Can Form 2220 Columns

Instructions and Help about Can Form 2220 Columns

Hello and welcome to another tutorial video. This time around, we're going to be looking at an Excel related topic, which is how to clean up data. Now, over here on the screen, I have some address data. These might have been addresses from customer orders or addresses from employees or customers in our database, or something like that. But in any case, the address data is all here. These are all US addresses and you can look at it and see that it's really horribly formatted. The spacing is all off, there are extra spaces, some of the states are capitalized, some are not capitalized, some are partially capitalized, the zip codes are all over the place, there are leading spaces in the beginning. So, the bottom line is that there are a lot of problems with this data. And what we like to do when we get data like this is go in and make it easier to manipulate and fix all these problems. So, fix the spacing, make it so that we can separate out all the different data, so we have the street address, the city name, the state, and the zip code all in different columns. This will make it much easier to manipulate and analyze the data. The reason why this happens, the reason this topic is relevant is because oftentimes you'll be pasting in data from websites or PDFs or other sources and you get a lot of these problems. You get a lot of ugly formatting, you get a lot of extra spaces, non-printable characters, and other things like that. Another issue is that, as is the case here and in a lot of cases, you may have data grouped together in a way that is not very useful. And this happens all the time on...