Excel Formulas to Pad the Text into Equal Length ~ Simple Tricks!!

Have you ever tried to pad the text strings into equal length in Excel? In this chapter, we will show the simple formulas to solve this problem. Let’s get into this article!! Get an official version of ** MS Excel** from the following link: https://www.microsoft.com/en-in/microsoft-365/excel

General Formula:

Use the below formula to pad the text into equal length in Excel.

=A1&REPT(“*”,count-LEN(A1))

Syntax Explanations:

REPT – The REPT function repeats characters a given number of times.
LEN – This function returns the length of a given text string as the number of characters. Read more on the LEN function.
A1 – It represents the input value.
Count – It specifies the text length.
Comma symbol (,) – It is a separator that helps to separate a list of values.
Parenthesis () – The main purpose of this symbol is to group the elements.

Practical Example:

Refer to the below example image.

Here, we will enter the input values in Column B.
Now we are going to pad the input values into equal length.

Select any cell and type the above-given formula.

Finally, press the ** ENTER** key, you can get the result as shown below.

Closure:

Hope you like this article on how to pad the text into equal length in Excel. Hope you like it. Leave a comment or reply below to let me know what you think!

Thank you so much for visiting *Geek Excel!! **If you want to learn more helpful formulas, check out Excel Formulas *!! **