Easily learn to Add Text to the End of a Number in Excel. This simple trick will allow you to format numbers with specified Text at the end.
Let’s look as the following data set example. The correct format we need is 948548S .
Number 948548 - Correct 948548S 945845 - Correct 945845S 954284 - Correct 954284S 924584 - Correct 924584S 542154 - Correct 542154S 584258 - Correct 584258S 548545 - Correct 548545S
Instead of individually adding an “S” to each cell, you can use the following formula.
Syntax: “&” Function
=A2&"S"