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 .

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

Add Letter to End Number in Excel


Add Letter to End number in Excel

Leave a Comment

Your email address will not be published. Required fields are marked *

Scroll to Top
Send this to a friend