cutting words with Len and Left and vlookup RedAlien Jan 14th 2022 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