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 Reply

SUMIFS Function

The SUMIFS function in Excel sums up particular cells based upon multiple criteria. The Sumif Function is only able to

Read More »

ROUNDUP Function

The ROUNDUP function in Excel rounds numbers up a specified decimal place. This function rounds up all of the numbers.

Read More »
Scroll to Top