Question

How to add leading space for a text string in a cell in excel?

Answer 1

Select the cells you want to use, type this formula =LEFT(A1&"*****",5), press Enter key, and drag fill handle over thecells 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.