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

FLOOR Function

The FLOOR function in Excel rounds a given number down to the nearest specified multiple. Unlike the MROUND function, the

Read More »

Average Function

AVERAGE (Arithmetic Mean) Finding the arithmetic mean in Excel is very easy. Just like in basic math, you add up

Read More »

AVERAGEIF Function

AVERAGEIF (Arithmetic Mean) – Single Criteria IF statement Use the AVERAGEIF Function to find the arithmetic mean in Excel while

Read More »
Scroll to Top