How to truncate/trim digit or text string with Kutools For Excel
In this video tutorial, we are going to show, How to truncate/trim digit or text string with Kutools For Excel.
Actually, if you have Kutools for Excel – a handy tool, you can apply its Remove by Position utility to quickly remove the characters you do not need for truncating the string.
► Truncate Strings With Formula
For instance, here I just truncate the strings into six digit from left, and below formula can do a favor.
Select a blank cell next to the string you want to truncate, and enter this formula =LEFT(A1,6) (A1 is the string you use, and 6 indicates truncate the string into six characters), then drag fill handle over the cells which also need this formula.
Tip: If you want to truncate string from right side or middle, you can apply below formula：
Truncate into 4 digit from right side: =RIGHT(A1,4)
Truncate into 3 digit from the fourth character: =MID(A1,4,3)
📌 Download Links:
➤ Download Dose for excel premium tools : https://bit.ly/dose-for-excel
➤ Get Dose for excel by using coupon code 25% OFF: Quizziin25
➤Get Kutools for Excel : https://bit.ly/ku-tools-for-excel
2. Kutools for Outlook : Brings multiple powerful features to Microsoft Office Outlook 2010 -2021 and Office 365.
Buy Now (Affiliated by ExtendOffice.com ): https://bit.ly/ku-tools-for-outlook
3. Kutools for Word : It is a powerful software that frees you from time-consuming operations which majority of Word users have to perform daily! It contains 100+ powerful functions and tools for saving hours of your time in Word.
Buy Now (Affiliated by ExtendOffice.com ) : https://bit.ly/ku-tools-for-word
4. Office Tab : It brings the tabbed user interface to Microsoft Office 2003, 2007, 2010, 2013, 2016, 2019, 2021 and Office 365 (include Word, Excel and PowerPoint). It gives users the ability to open, read, edit and manage multiple Office documents in the same tabbed window. Easy to deploy in your Enterprise or Organization. Supports all languages that are supported by Microsoft Office.
Buy Now (Affiliated by ExtendOffice.com ) : https://bit.ly/office_tab
5. Office Tab Enterprise : Office Tab brings the tabbed user interface to Microsoft Office 2003, 2007, 2010, 2013, 2016, 2019, 2021 and Office 365 (include Word, Excel, PowerPoint, Publisher, Access, Project and Visio). It gives users the ability to open, read, edit and manage multiple Office documents in the same tabbed window. Easy to deploy in your Enterprise or Organization. Supports all languages that are supported by Microsoft Office.
Buy Now : https://bit.ly/Office_Tab_Enterprise (Affiliated by ExtendOffice.com )
➤ Our Social Media Link :
➤ Facebook Page : / quizziin
➤ Instagram : / quizziin
➤ Reddit : / quizziin
#excelmacro
#excelmacrotips
#excelvbaforbeginners
#excelvbatutorial
#exceltutorial