Posts by RedAlien

If you modify the formula to substitute the first space " " with "-" then you will get

=SUBSTITUTE(LEFT(A5,FIND(" ",A5)+2)," ","-",1)

and copy down