LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Steved
 
Posts: n/a
Default SUBSTITUTE(Outward!B5,"-","0")+0



SUBSTITUTE(Outward!B5,"-","0")+0

from 1-100-1 to 0110001 please

Ok I was kindly given the above formula Which I am grateful and useful.
Please can I Have it so it deletes the first - in 1-100 to be 1100
the end result woud be 0110001 from the original 1-100-1 value
in brief first - deleted, the second - replace with a 0.

Thankyou for your time on this issue.

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 09:13 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"