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.