Join Dennis Taylor for an in-depth discussion in this video Managing leading zeroes in zip, numerical, and text codes, part of Cleaning Up Your Excel 2010 Data.
If you use numeric codes that begin with zeros--and of course some ZIP codes…do begin with zero--…you need to be able to see and retain those zeros.…There are a couple techniques we want to take a look at there.…First of all, in Column A, let's imagine that someone typed the ZIP codes, maybe…looking at a sheet of paper, heads down, just typing the zeros where…appropriate, but the zeros actually didn't appear.…So you can imagine, in Cell A5, for example, whoever was typing this probably…typed 02299, as I'm typing here.…So what happens though when we press Enter?…The zero doesn't appear there.…
Now we wouldn't have to go through any shenanigans or anything unusual…here; simply format Column A--right- click > Format Cells. And ideally, you…do this before you put the data in--it makes a bit more sense--and you'll see…correct entries as we go.…There is a special category on the Number tab in Format Cells.…It's called Special. And we got two ZIP code entries:…Zip Code, the standard five digit, or the Zip Code + 4.…
- Moving or inserting rows and columns of data with a simple drag
- Using Text to Columns
- Harnessing the Find and Replace command to replace data at the character level
- Dealing with special characters and wildcards during search
- Converting dates with text functions
- Converting text data to values/numbers
- Checking and correcting spelling mistakes
- Splitting data into multiple columns via the Text to Columns feature
- Combining data from different columns via concatenation
Skill Level Intermediate
Q: Where can I learn more about Excel formulas?
A: Discover more on this topic by visiting Excel formulas on lynda.com.