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 |