excel add trailing spaces to text code example

Example: excel add trailing spaces to text

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