Current location - Quotes Website - Signature design - How does EXCEL automatically add a character after entering a number in several cells? For example, if I type 123, I will automatically add "#" to my signature.
How does EXCEL automatically add a character after entering a number in several cells? For example, if I type 123, I will automatically add "#" to my signature.
There are two ways.

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.