Inside the REPT function, the text to repeat is provided as a single asterisk ("*"). The number of asterisks needed for each value is determined with with the LEN function in this bit of code here: We start with 12, then subtract the length of the text in column B. In cell B5, “Sebastian” is 9 characters, so the result is 3. The formula is evaluated like this: The results in column C is formatted with a monospaced font (Courier New) to clearly show all strings are the same length.

Dave Bruns

Hi - I’m Dave Bruns, and I run Exceljet with my wife, Lisa. Our goal is to help you work faster in Excel. We create short videos, and clear examples of formulas, functions, pivot tables, conditional formatting, and charts.