How to pad cells to a fixed length in Excel?

How to pad cells to fixed length for a neat look while the data values you type differed in text length in Excel? In this article, you may get the solution. Pad cells to fixed length

Pad cells to fixed length

Pad cells to fixed length

To pad cells to a fixed length, you just need a simple formula.

Select the cells you want to use, type this formula =LEFT(A1&"*****",5), press Enter key, and drag fill handle over the cells as you need. In the formula A1 is the cell you use to fix length, * is the character you want to fill, 5 indicates to fix text length in 5 digits. See screenshot:

Tip: Here are some formulas also working, you can choose one of them as you need.

=RIGHT("*****"&A1,5)

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

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

Easily Combine multiple sheets/Workbook into one Single sheet or Workbook

To combinne multiples sheets or workbooks into one sheet or workbook may be edious in Excel, but with the Combine function in Kutools for Excel, you can combine merge dozens of sheets/workbooks into one sheet or workbook, also, you can consolidate the sheets into one by several clicks only.  Click for full-featured 30 days free trial!

Kutools for Excel: with more than 300 handy Excel add-ins, free to try with no limitation in 30 days.

Relative Articles:

• How to add leading zero to fixed number length in Excel?