Quantcast

I4C

Find and Replace for Data Cleanup

Find and Replace for Data Cleanup in Excel

Find and Replace can fix repeated text patterns much faster than editing cells one by one. It is helpful when names, labels, abbreviations, or date styles need to be cleaned up consistently.

Previous lesson: Remove Duplicates

Next step: Continue to Data Validation and Dropdown Lists.

 

 

Internet4classrooms is a collaborative effort by Susan Brooks and Bill Byles.
 

  

Use of this Web site constitutes acceptance of our Terms of Service and Privacy Policy. 

10 desktop not tablet not iPad device-width