replacing one number with another
 

Have some single digit numerical data and need to recode one single digit
number with another. What function do i use in the formula bar. Any help
appreciated. Thanks

replacing one number with another
 

Edit Find & Replace is the usual way. If you need to use a function, then
if the data is in column A, then in another column enter:

=IF(A1=7,3,A1) this will replace each 7 with a 3.
--
Gary''''s Student - gsnu200803


"Ann2" wrote:

Have some single digit numerical data and need to recode one single digit
number with another. What function do i use in the formula bar. Any help
appreciated. Thanks