| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Replace "-" with "0"
Hello from Steved
I have a formula =Inward!B5 ok it gets the value 1-100-1 Can I please add to above formula to change the - to 0 which will give me 1010001. Thankyou. |
|
#2
|
|||
|
|||
|
Try...
=SUBSTITUTE(Inward!B5,"-","0") ....which will return the number as a text value. If you want to return it as a numeric value, try the following instead... =SUBSTITUTE(Inward!B5,"-","0")+0 Hope this helps! In article , Steved wrote: Hello from Steved I have a formula =Inward!B5 ok it gets the value 1-100-1 Can I please add to above formula to change the - to 0 which will give me 1010001. Thankyou. |
|
#3
|
|||
|
|||
|
Excellent and thankyou very much.
"Domenic" wrote: Try... =SUBSTITUTE(Inward!B5,"-","0") ....which will return the number as a text value. If you want to return it as a numeric value, try the following instead... =SUBSTITUTE(Inward!B5,"-","0")+0 Hope this helps! In article , Steved wrote: Hello from Steved I have a formula =Inward!B5 ok it gets the value 1-100-1 Can I please add to above formula to change the - to 0 which will give me 1010001. Thankyou. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Search and replace | Excel Worksheet Functions | |||
| replace absolute references | Excel Worksheet Functions | |||
| REPLACE outside of highlighted column | Excel Worksheet Functions | |||
| Replace Number with Text using Macro | Excel Discussion (Misc queries) | |||
| VB Find and Replace | Excel Worksheet Functions | |||
Linear Mode
