| 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 | |||
Hybrid Mode
