Search and Replace

 

Menu location: Data_Cleaning and Encoding_Search and Replace.

 

This function searches for and replaces the values that you specify.

 

For more complex search_and_replace functionality where an expression such as ">=0" is required, not just exact matches, please see Extract a Subset of Data.

 

In addition, for filtering worksheet rows in the same way that Excel uses filters please see Filters.

 

 

Copyright © 2000-2016 StatsDirect Limited, all rights reserved. Download a free trial here.