Add Text to Beginning Number in Excel

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 
Add Text to Number

Result

Add Text to Number Final

Leave a Reply

Scroll to Top