Join Dennis Taylor for an in-depth discussion in this video Filling in missing title information, part of Cleaning Up Your Excel 2010 Data.
Sometimes for printing reasons, or just for clear visual display, all but the…first entry of a series of repeating entries have been deleted.…For example, as we look in column A, we don't see the department name ADC…repeated in rows 3 through 6.…We don't see Admin Training repeated in row 8 downward. And setting up data like…this does make the data easier to read.…But if we want to sort this data by Status or Benefits or Salary or any other…column, once we do that, we don't have any way to return to this layout.…
In other words, we actually need to fill in Column A with the data that's missing.…So what we like to do is to have ADC appear here, here, here, and here.…Now, this might be a huge list.…It happens to be about 700 names.…It could be 7,000, hundreds of thousands possibly.…What we need to do is use a technique not so widely used that essentially…allows us, first of all, to select the blank cells here, and then what we are…going to do is write a formula for each of the cells that gets data from the cell above.…
- 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.