If you modify the formula to substitute the first space " " with "-" then you will get
MVIS-US |
EHTH-US |
=SUBSTITUTE(LEFT(A5,FIND(" ",A5)+2)," ","-",1)
and copy down
If you modify the formula to substitute the first space " " with "-" then you will get
MVIS-US |
EHTH-US |
=SUBSTITUTE(LEFT(A5,FIND(" ",A5)+2)," ","-",1)
and copy down