Easily learn to Add Text to the beginning of a Number in Excel. In many instances, you are required to format number with Text at the beginning. The vast majority of companies using software such as PLEX or other ERP systems use a “Letter” in front of Serial Numbers.
Let’s look as the following data set example. The correct format we need is S948548.
Number 948548 - Correct S948548 945845 - Correct S945845 954284 - Correct S954284 924584 - Correct S924584 542154 - Correct S542154 584258 - Correct S584258 548545 - Correct S548545
Instead of individually adding an “S” to each cell, you can use the following formula.
Syntax: “&” Function
="S"&A2