![Trending Articles on Technical and Non Technical topics](/images/trending_categories.jpeg)
Data Structure
Networking
RDBMS
Operating System
Java
MS Excel
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
Physics
Chemistry
Biology
Mathematics
English
Economics
Psychology
Social Studies
Fashion Studies
Legal Studies
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
How to Add Semicolon to Each Cell in Excel?
If you have a huge Excel sheet with lots of data and there is a requirement to add a semicolon to each cell, then you wouldn't surely do it manually. In this tutorial, we will show you a simple hack that you can use for this purpose.
Adding Semicolon to Each Cell Using "&" Operator
Let's start with the first method. You can add a semicolon to each cell using the "&" operator.
Step 1
Let us consider we have the following Excel sheet that contains a list of numbers and names. We will be using the concept of adding suffix to a list of data.
![](https://www.tutorialspoint.com/assets/questions/media/483469-1670328023.jpg)
Click an empty cell where you want to show the first result and then enter the formula =A1&";" in the formula box and hit the "Enter" button. It will append a semicolon to the text given in "A1". See the following screenshot:
![](https://www.tutorialspoint.com/assets/questions/media/483469-1670328069.jpg)
Step 2
To get all the other results, just darg down from the corner till all the results are filled.
![](https://www.tutorialspoint.com/assets/questions/media/483469-1670328101.jpg)
Adding Semicolon to Each Cell using CONCAT
This is the second method. You can use the CONCAT method to concatenate a semicolon at the end of each cell.
Step 1
Let us consider the same data which we used in the above example. Click an empty cell where you want to display the first result, enter the formula =concat(A1,";") in the formula box, and hit the "Enter" button. It will produce the following result:
![](https://www.tutorialspoint.com/assets/questions/media/483469-1670328133.jpg)
Step 2
To get all the other results, just darg down from the corner till all the results are filled. Our final output will look like the one shown below:
![](https://www.tutorialspoint.com/assets/questions/media/483469-1670328175.jpg)
Conclusion
In this tutorial, we used two different methods to demonstrate how you can add a semicolon to the existing data in an Excel sheet in a very easy and efficient way.