| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I replace negative values by a character
I need to replace all negative values in my data set by a letter i.e "B"
|
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I replace negative values by a character
assuming your data is number...
ctl+H to replace in Find what type -* in replace with type B this should replace all the negative numbers with B "Blue" wrote: I need to replace all negative values in my data set by a letter i.e "B" |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| find a replace character question | Excel Discussion (Misc queries) | |||
| replace new line character | Excel Discussion (Misc queries) | |||
| How do I replace a BEL Character of 7 with a space | Excel Discussion (Misc queries) | |||
| Formula to make Negative Values Positive & Positive Values Negative? | Excel Discussion (Misc queries) | |||
| How do I replace a character with another? | Excel Discussion (Misc queries) | |||
Linear Mode
