Truncate into 3 digit from the fourth character: =MID(A1,4,3)Įasily and quickly remove character by same position from each cell in Excel Truncate into 4 digit from right side: =RIGHT(A1,4) Tip: If you want to truncate string from right side or middle, you can apply below formula: 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. Have you any tricks to quickly solve it in Excel?įor instance, here I just truncate the strings into six digit from left, and below formula can do a favor. In some times, there is a list of strings, which includes some long strings, and for neat and tidy, you may want to truncate the strings into a fixed length as below screenshot shown. How to truncate number/text string in Excel?
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |