excel complete with space code example Example: excel complete with space =LEFT(A1 & REPT(" ",10),10)