Join Dennis Taylor for an in-depth discussion in this video Combining data from different columns via concatenation, part of Cleaning Up Your Excel 2010 Data.
Sometimes you need to pull data together from different locations within a worksheet.…The data in columns A, B, and C is structured in such a way that it's ideal for…sorting by last name, and even first name if necessary.…But suppose you want to take that information and create the kind of names that…you would put on mailing labels.…In Cell D2, for example, what we would like to see here is Mark R. Baker, and…just below that, Sheila H. Hansen.…We can pull data together by using the Concatenate function or a technique that…pulls the data together.…
Let's take a look at both of these.…The function is called Concatenate. And we simply want to pull the data from B2--…that's the first name where we see Mark-- comma, and we would also like to see…a space after Mark.…So double quote, space, double quote, and a comma, and now we want to see the middle initial--it's in C2.…Recognize that some of the names below don't have a middle initial.…Following the middle initial another comma, double quote, space, double quote, comma, and now the…
- 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.