Tip: Other languages are Google-Translated. You can visit the English version of this link.
Log in
x
or
x
x
Register
x

or

How to delete string after nth character in Excel?

In some cases, you may want to remove all strings after nth character from cells in Excel. If you have few of cells needed to remove strings after nth character, you can delete them manually. However, if there are hundreds of cells, that must be tired to delete strings one by one. Now this tutorial tells you the quick ways to remove strings after nth character in Excel, please read the below details.

Remove all string after nth character with formula

Remove string in specific position by Remove by Position

Excel Productivity Tools

Office Tab: Bring powerful tabs to Office (include Excel), just like Chrome, Safari, Firefox and Internet Explorer. Save you half the time, and reduce thousands of mouse clicks for you. 30-day Unlimited Free Trial

Kutools for Excel: Save 70% of your time and solve 80% Excel problems for you. 300+ advanced features designed for 1500+ work scenario, make Excel much easy and increase productivity immediately. 60-day Unlimited Free Trial


arrow blue right bubble Remove all string after nth character with formula


You can use below formula to remove all string after nth character.

Kutools for Excel, with more than 120 handy Excel functions, enhance your working efficiency and save your working time.

Take instance, you want to delete all strings after the third character, and select a cell and type this formula =LEFT(A1,3) into it, press Enter key and drag the autofill handle down to cells.

doc delete after nth character 1
doc delete after nth character 2

Tip: In above formula, you can change 3 to any nth as you need. For example, if you want to remove strings after 4th character, use this formula =LEFT(A1,4).


arrow blue right bubble Remove string in specific position by Remove by Position

If you have Kutools for Excel, you can use the Remove by Position to quickly remove strings after nth character, and also can specify how many characters you will remove.

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 data range and click Kutools > Text > Remove by Position. See screenshot:

doc delete after nth character 3

2. In the Remove by Position dialog, type 999 into Numbers textbox, and the check Specify and type 4 into following textbox. You can see the results shown on the preview pane.

Tip: If you want to remove string after nth character, you just need to type n + 1 into the Specify textbox.

doc delete after nth character 4

3. Then click Ok or Apply. The string after 3rd has been removed from each cell.

Note: If you just want to remove 3 characters after 3rd character of the string, you can type 3 into Numbers textbox, and check Specify and type 4 into it.

doc delete after nth character 5

Click here to know more details about Remove by Position.

Click here to free download Kutools for Excel


Excel Productivity Tools

Ribbon of Excel (with Kutools for Excel installed)

300+ Advanced Features Increase Your Productivity by 70%, and Help You To Stand Out From Crowd

Would you like to complete your daily work quickly and perfectly? Kutools for Excel brings 300+ cool and powerful advanced features (Combine workbooks, sum by color, split cell contents, convert date, and so on...) for you.

  • Designed for 1500+ work scenarios, helps you solve 80% Excel problems.
  • Save a lot of work time, leave much time for you to love and care the family and enjoy a comfortable life now.
  • Reduce thousands of keyboard and mouse clicks every day, relieve your tired eyes and hands.
  • Become an Excel expert in 3 minutes. No longer need to remember any painful formulas and VBA codes.
  • 60-day unlimited free trial. 60-day money back guarantee. Free upgrade and support for 2 years. Buy once, use forever.
  • Being used by 110,000 elites and 300+ well-known companies.

Office Tab Brings Efficient And Handy Tabs to Office (include Excel), Just Like Chrome, Firefox, And New IE

  • Increases your productivity by 50% when viewing and editing multiple documents.
  • Reduce hundreds of mouse clicks for you every day, say goodbye to mouse hand.
  • Open and create documents in new tabs of same window, rather than in new windows.
  • One second to switch between dozens of open documents!
Say something here...
symbols left.
You are guest ( Sign Up? )
or post as a guest, but your post won't be published automatically.
Loading comment... The comment will be refreshed after 00:00.

Be the first to comment.