Completing empty spaces with text

“As I make to complete the field (cell) of the extensive one with some caracter (normally “*”), since I had that to determine a fixed width for the field? Your function makes this”

We go to use function REPT of Excel to add text to the end of the text of the VExtenso. This function REPT possesss two parameters, the first one is the text that will be repeated, and according to the number of times that will be repeated. Example:
 

=REPT (“*”; 10)

result:

**********

Now together with the VExtenso:

=vextenso (90) & REPT (“x - -”; 100)

result:

ninety Reals x - - x - - x - - x - - x - - x - - x - - x - - x - - x - - x - -

However, the text goes to be well great e goes to leave the cell, but you can skirt this of the following form: in the cell to the side of that you possess the VExtenso, place only one space, see in images 1 and 2

Image 1: The text passed of cell C and “it invaded” the following cells

Image 2: Placing a space in the D3 cell, the C3 cell did not invade more the others:

Fórum also sees other answers for this question in ours:

text for extensive this exceeding the right edge