Add Text to End Number in Excel

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" 
Add Letter to End Number in Excel

Result:

Add Letter to End number in Excel

Leave a Reply

Scroll to Top