replacing one number with another

  • Thread starter Thread starter Ann2
  • Start date Start date
A

Ann2

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
 
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.
 
Back
Top