How to Delete Characters from Beginning or End of the Text Strings?
Tags: deletecharactersfrom, kutoolsexceltutorial, kutools
Published: 2020-11-02 12:07:13

---
title: How to Delete Characters from Beginning or End of the Text Strings?
published: true
date: 2020-11-02 12:03:21 UTC
tags: DeleteCharactersfrom,KutoolsExcelTutorial,Kutools
canonical_url: https://geekexcel.com/how-to-delete-characters-from-beginning-or-end-of-the-text-strings/
---

In this guide, we will explain how to **Remove or Delete Characters from Beginning or End of the Text Strings** in **Excel Office 365** using **Kutools.** Get an official version of MS Excel from the following link: **[https://www.microsoft.com/en-in/microsoft-365/excel](https://www.microsoft.com/en-in/microsoft-365/excel)**

**Note:** [kutools for Excel](https://geekexcel.com/get-kutools-for-ms-excel-2019-2016-2013-2010-2007-office-365/) has more than 180 features which are used to complete the difficult task with several clicks. If you want to use Kutools, you need to install it from Excel’s official website.
## Remove Certain Number of Characters from the Beginning of Text String:

If you want to remove certain numbers of characters from the beginning or left of the text string, follow the below steps.

- First, you need to **select the range** that you want to remove certain characters.

![Example](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/Example-2.png)<figcaption id="caption-attachment-16701">Example</figcaption>

- Go to the **Kutools Tab, select** the **Text** option, **choose** the **Remove by Position** option from the menu.

![Select Remove by position option](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/Select-Remove-by-position-option.png)<figcaption id="caption-attachment-16702">Select Remove by Position option</figcaption>

- Then, it will open the **Remove by position Dialog Box**.
- **Numbers –** In this box, you need to **specify the number of characters** to be removed.
- **Position –** Here, you need to **check** the **From left** option.
- Then, **click** the **OK** button.

![Click the OK button](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/Click-the-OK-button.png)<figcaption id="caption-attachment-16703">Click the OK button</figcaption>

- Now, you can see that the specified number of characters has been removed from the range of text strings as shown in the below image.

![Result](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/Result-1.png)<figcaption id="caption-attachment-16704">Result</figcaption>

## Delete Certain Number of Characters from End of the Text String:

You can also delete a certain number of characters from the end of the text string, do as follows.

- Firstly, you need to **select the range** that you want to remove certain characters.

![Select the range](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/1-1.png)<figcaption id="caption-attachment-16706">Select the range</figcaption>

- On the **Kutools Tab, select** the **Text** option, **choose** the **Remove by Position** option from the menu.

![Select Remove by position option](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/Select-Remove-by-position-option.png)<figcaption id="caption-attachment-16702">Select Remove by Position option</figcaption>

- Then, it will open the **Remove by position Dialog Box**.
- **Numbers –** In this box, you need to **specify the number of characters** to be removed.
- **Position –** Here, you need to **check** the **From right** option.
- Then, **click** the **OK** button.

![Remove by position Dialog Box](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/2.png)<figcaption id="caption-attachment-16708">Remove by position Dialog Box</figcaption>

- Now, the specified characters have been deleted from the right of the text strings as shown in the below image.

![Output](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/3.png)<figcaption id="caption-attachment-16709">Output</figcaption>

## Remove Certain number of Characters from a Specified Position of Text String:

With this utility, you can remove a certain number of characters from a specified position of a text string. To do this, follow the below steps.

- You need to **select the range** that you want to remove certain characters.

![Input Range](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/4.png)<figcaption id="caption-attachment-16710">Input Range</figcaption>

- Go to the **Kutools Tab, select** the **Text** option, **choose** the **Remove by Position** option from the menu.

![Select Remove by position option](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/Select-Remove-by-position-option.png)<figcaption id="caption-attachment-16702">Select Remove by Position option</figcaption>

- Then, it will open the **Remove by position Dialog Box**.
- **Numbers –** In this box, you need to **specify the number of characters** to be removed.
- **Position –** Here, you need to **check** the **Specify** option and select the character position using the given drop-down list.
- Then, **click** the **OK** button.

![Remove by position Dialog Box](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/5.png)<figcaption id="caption-attachment-16711">Remove by position Dialog Box</figcaption>

- At last, you can see that the characters you specified have been removed from the text strings. Refer to the below screenshot.

![Result](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/6.png)<figcaption id="caption-attachment-16712">Result</figcaption>

## End of the Article:

In this guide, you can understand the steps to **Remove or Delete Characters from Beginning or End of the Text Strings** in **Excel Office 365** using **Kutools.** Drop your **feedback** in the comment section. Thanks for visiting **[Geek Excel.](https://geekexcel.com/)** Keep Learning!

### Read Also:

- [Convert Cell Reference to Relative/Absolute Reference in Excel 365!!](https://geekexcel.com/wp-admin/post.php?post=16606&action=edit)
- [How to Select Cells Based on Color/Formatting in Excel Office 365?](https://geekexcel.com/wp-admin/post.php?post=16618&action=edit)