Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
replacing FIRST NUMBER-SECOND NUMBER with SECOND NUMBER | New Users to Excel | |||
Replacing a number value with text from array | Excel Worksheet Functions | |||
Replacing dash in item number | Excel Discussion (Misc queries) | |||
INTRICATE PROBLEM- How to find multiple text,excluding "H", in a multiple range of cells, then replacing 0 with another number in another cell | Excel Worksheet Functions | |||
Replacing a number with a description in Excel | Excel Worksheet Functions |