Join Dennis Taylor for an in-depth discussion in this video Deal with special characters, wildcards, and REPLACE function, part of Excel 2016: Cleaning Up Your Data.
- [Instructor] In this worksheet called Replace,…we've got some code numbers in column B.…Some codes are positional, meaning that maybe…the third character has to do with a color of an item,…the fourth character might have to do…with the year that it was made.…These could have something to do with size, location,…any number of different things.…We need to make some changes.…In the previous movie, you might have learned about…not only the Substitute function,…but also a command called Replace.…The Substitute function and the Replace command…are based on content, but there's a Replace function,…and it can be a little confusing as we talk about this,…the Replace function is unlike the Replace command.…
The Replace function is based on location or position.…I'm going to zoom in on this data,…hold down the Control key and use the mouse wheel.…We need to make a change in the coding structure here.…The second and third characters, regardless of content…as we look at the different data here,…we need to change those to a different number.…
Lynda.com is a PMI Registered Education Provider. This course qualifies for professional development units (PDUs). To view the activity and PDU details for this course, click here.
The PMI Registered Education Provider logo is a registered mark of the Project Management Institute, Inc.
- Moving and inserting rows and columns of data with a simple drag
- Replacing data at the character level
- Converting dates with text functions
- Converting text data to values
- Using the CONCAT and TEXTJOIN functions to combine data
- Splitting data into columns via the Text to Columns feature
- Using Flash Fill for faster combining and splitting
- Checking and correcting spelling mistakes