Skip to content
Free Excel Tutorials
  • Home
  • Excel For Beginners
  • Excel Intermediate
  • Advanced Excel For Experts

Data Analysis

  • How to count table columns in Excel
  • How To Insert and Customize Sparklines in Excel
  • How to create Gauge Chart in Excel
  • Calculate Conditional Percentile ‘IF’ in table in Excel
  • How to Create Column Chart in Excel

References

  • LOOKUP function: Description, Usage, Syntax, Examples and Explanation
  • How to get last row in numeric data in Excel
  • Create hyperlink with VLOOKUP in Excel
  • How to use Excel FORMULATEXT function
  • How to use Excel COLUMN Function

Data Validations

  • Excel Data validation whole percentage only
  • Excel Data validation don’t exceed total
  • Excel Data validation must not contain
  • Excel Data validation exists in list
  • Excel Data validation must contain specific text

How to pad text to match equal length in Excel

by

To pad text to an equal length using another character, you can use a formula based on the REPT and LEN functions.

Formula

=A1&REPT("*",count-LEN(A1))

Explanation

In the example shown, a formula is used to append a variable number of asterisks (*) to values in column B so that the final result is always 12 characters in length. The formula in C5 is:

=B5&REPT("*",12-LEN(B5))

How this formula works

This formula concatenates the original value in column B to a string of asterisks (*) assembled with the REPT function so that the final result is always 12 characters:

REPT("*",12-LEN(B5))

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:

12-LEN(B5)

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:

="Sebastian"&REPT("*",12-LEN(B5))
="Sebastian"&REPT("*",12-9)
="Sebastian"&REPT("*",3)
="Sebastian"&"***"
="Sebastian***"

The results in column C is formatted with a monospaced font (Courier New) to clearly show all strings are the same length.

Post navigation

Next Post:

Create One-dimensional and Two-dimensional Array

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Learn Basic Excel

Ribbon
Workbook
Worksheets
Format Cells
Find & Select
Sort & Filter
Templates
Print
Share
Protect
Keyboard Shortcuts

Categories

  • Charts
  • Data Analysis
  • Data Validation
  • Excel Functions
    • Cube Functions
    • Database Functions
    • Date and Time Functions
    • Engineering Functions
    • Financial Functions
    • Information Functions
    • Logical Functions
    • Lookup and Reference Functions
    • Math and Trig Functions
    • Statistical Functions
    • Text Functions
    • Web Functions
  • Excel VBA
  • Excel Video Tutorials
  • Formatting
  • Grouping
  • Others

Logical Functions

  • AND function: Description, Usage, Syntax, Examples and Explanation
  • XOR function: Description, Usage, Syntax, Examples and Explanation
  • How to use Excel XOR Function
  • How to return blank in place of #DIV/0! error in Excel
  • OR function Examples in Excel

Date Time

  • DATEVALUE function: Description, Usage, Syntax, Examples and Explanation
  • Get days, hours, and minutes between dates in Excel
  • How to calculate months between dates in Excel
  • MONTH function: Description, Usage, Syntax, Examples and Explanation
  • Get first day of month in Excel

Grouping

  • Map text to numbers in Excel
  • Group numbers at uneven intervals in Excel
  • If cell contains one of many things in Excel
  • Calculate conditional mode with criteria in Excel
  • Group times into 3 hour buckets in Excel

General

  • Index and match on multiple columns in Excel
  • Count cells that contain errors in Excel
  • With vs Without Array Formula in Excel
  • Print Excel Sheet In Landscape Or Portrait
  • How to calculate percent variance in Excel
© 2026 xlsoffice . All Right Reserved. | Teal Smiles | Abbreviations And Their Meaning