How to add semicolon to each cell in Excel?
It’s easy to add semicolon to the end of one cell, but it must be time-consuming and tedious to add semicolons for hundreds of cells in Excel. Now I introduce you some tricks to add semicolon to the end of each cell in Excel to free you from typing semicolon one by one.
|Kutools for Excel's Remove Characters utility can help you remove the characters you don't need, such as remove numeric string, alpha string, non-numeric string and so on.|
Here is a very simple formula can add semicolon to the end of each cell in a list.
Select a cell next to your first data, and type this formula =A2&";" into it, press Enter key, then drag the autofill handle down to the cells you need.
If you have Kutools for Excel, you can use the Add Text function to quickly add semicolon to any position of each cell.
|Kutools for Excel, with more than 120 handy Excel functions, enhance your working efficiency and save your working time.|
After free installing Kutools for Excel, please do as below:
1. Select the email cells, and click Kutools > Text > Add Text. See screenshot:
2. Then in the Add Text dialog, type the semicolon ; into Text box, and check After last character option, you can see the results in the right preview pane.
3. Click Ok or Apply, the each email has been added a semicolon.
|Kutools' Convert Time utility can quickly convert a time to decimal hours, minutes, seconds.|
Recommended Productivity Tools
Bring handy tabs to Excel and other Office software, just like Chrome, Firefox and new Internet Explorer.
Amazing! Increase your productivity in 5 minutes. Don't need any special skills, save two hours every day!
300 New Features for Excel, Make Excel Much Easy and Powerful:
- Merge Cell/Rows/Columns without Losing Data.
- Combine and Consolidate Multiple Sheets and Workbooks.
- Compare Ranges, Copy Multiple Ranges, Convert Text to Date, Unit and Currency Conversion.
- Count by Colors, Paging Subtotals, Advanced Sort and Super Filter,
- More Select/Insert/Delete/Text/Format/Link/Comment/Workbooks/Worksheets Tools...