1) Use a function, such as A 1: 123, then the function can be completed in B 1 = A 1&; "#"
2) Use cell settings, right-click to select a cell, select Set Cell Format, and customize. Type input # # # # # "# ",where the preceding # indicates your input, the number must be greater than or equal to the character you entered, and the following # is your suffix.