excel add trailing spaces code example

Example: excel add trailing spaces

=LEFT(A1 & REPT(" ",10),10)