If you ever want to remove a certain number of characters from the beginning or from the end of text in Excel or even remove certain characters by specifying the position to start remove characters from with specifying number of characters to be removed, then you will need to use this powerful utility that accomplish this task with one click otherwise you will need to write VBA code. Dose for Excel‘s Remove by Position utility can remove any type of characters you want from text in Excel cells with one click on huge Excel sheets.
- Remove certain number of characters from the beginning of text
- Remove certain number of characters from the end of text
- Remove certain number of characters from a specified position
Click DOSE » Text » Remove by Position
![Excel Remove By Position](https://zbrainsoft.com/wp-content/uploads/2022/08/excel-remove-by-position.png)
![Excel Remove By Position](https://zbrainsoft.com/wp-content/uploads/2022/06/arrow-direction-right-39651-1024x512.png)
![Excel Remove By Position](https://zbrainsoft.com/wp-content/uploads/2022/08/excel-remove-by-position-pane.png)
Remove certain number of characters from the beginning of text
- Example: remove first six characters from text, turn “Excel 2016-2007” into “2016-2007”.
- Select range of cells that you want to remove the characters from.
- Specify number of characters to be removed in Numbers box, then check From left option.
- Then click Apply. In below example, we will remove the first three characters from the beginning of text, “MS-” will be removed. You will see the result as shown in the below screenshot.
![Excel Remove By Position](https://zbrainsoft.com/wp-content/uploads/2022/08/excel-remove-by-position-from-left-test.png)
![Excel Remove By Position](https://zbrainsoft.com/wp-content/uploads/2022/06/arrow-direction-right-39651-1024x512.png)
![Excel Remove By Position](https://zbrainsoft.com/wp-content/uploads/2022/08/excel-remove-by-position-from-left-result.png)
Remove certain number of characters from the end of text
- Example: remove last five characters from text, turn “Excel 2016-2007” into “Excel 2016”.
- Select range of cells that you want to remove the characters from.
- Specify number of characters to be removed in Numbers box, then check From right option.
- Then click Apply. In below example, we will remove the last five characters from the end of text. You will see the result as shown in the below screenshot.
![Excel Remove By Position](https://zbrainsoft.com/wp-content/uploads/2022/08/excel-remove-by-position-from-right-test.png)
![Excel Remove By Position](https://zbrainsoft.com/wp-content/uploads/2022/06/arrow-direction-right-39651-1024x512.png)
![Excel Remove By Position](https://zbrainsoft.com/wp-content/uploads/2022/08/excel-remove-by-position-from-right-result.png)
Remove certain number of characters from a specified position
- Example: remove four characters starting from position six from text, turn “Excel 2016-2007” into “Excel-2007”.
- Select range of cells that you want to remove the characters from.
- Specify number of characters to be removed in Numbers box, then check Specify option.
- Then click Apply. In below example, we will remove “-2018” starting from position 6 for five characters length from text. You will see the result as shown in the below screenshot.
![Excel Remove By Position](https://zbrainsoft.com/wp-content/uploads/2022/08/excel-remove-by-position-specify-test.png)
![Excel Remove By Position](https://zbrainsoft.com/wp-content/uploads/2022/06/arrow-direction-right-39651-1024x512.png)
![Excel Remove By Position](https://zbrainsoft.com/wp-content/uploads/2022/08/excel-remove-by-position-specify-result.png)
Demo
More Features:
How to Remove Leading Or Trailing Or Extra Spaces In Excel
Remove Leading Or Trailing Or Extra Spaces From Excel Cells You can remove leading spaces,…
Dose for Excel Languages
Dose for Excel Multi-Language Dose for Excel Add-In supports many languages, you can change the…
Excel Batch Insert Option Buttons
Batch Insert Option Buttons In Excel Insert a batch of option buttons into selected cells…
Excel Random Generator
Generate Random Data (Numbers, Date, String, etc…) Sometimes you want to generate some random data…
How to Change Text Case In Excel
Change Case Of Excel Cells Text Change case of text in selected cells in Excel…
Excel Delete Blank Sheets
Delete All Empty Worksheets Excel Delete all blank or empty sheets in Excel one time…